Comparing data on 2 spredsheets
[Closed]
Report
E

E 
E 
11 replies
Game Start Now
 Posts
 138
 Registration date
 Thursday January 21, 2010
 Status
 Member
 Last seen
 May 8, 2019
=IF(ISNA(VLOOKUP(A1,Sheet1!A:A,1,0))=TRUE,"No","Yes")
Well Here Is Your Formula. If You Can Understand & Manage This Formula On Your Sheet Then Thats Good.
Else Check My Uploaded File Whenever You You Want To Download.......
Regards,
Naeem
Well Here Is Your Formula. If You Can Understand & Manage This Formula On Your Sheet Then Thats Good.
Else Check My Uploaded File Whenever You You Want To Download.......
Regards,
Naeem
Game Start Now
 Posts
 138
 Registration date
 Thursday January 21, 2010
 Status
 Member
 Last seen
 May 8, 2019
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book.
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book.
RayH
 Posts
 122
 Registration date
 Tuesday August 31, 2010
 Status
 Contributor
 Last seen
 June 20, 2016
This could be achieved by using VLOOKUP. There are many recent examples of this in this forum.
E
Example, if it helps:
Spreadsheet 1:
Postcode 1
Postcode 2
Postcode 4
Spreadsheet 2:
Postcode 1  yes
Postcode 2  yes
Postcode 3  no
Postcode 4  yes
Postcode 5  no
I'd like this done for all 12000 postcodes, without doing it 1 by 1. At the moment, I have to "find"  ctrl f  each postcode from spreadsheet 2, 1 by 1 on spreadsheet 1. Then I have to put manually if it is or isn't on spreadsheet 1 (yes/no)
Spreadsheet 1:
Postcode 1
Postcode 2
Postcode 4
Spreadsheet 2:
Postcode 1  yes
Postcode 2  yes
Postcode 3  no
Postcode 4  yes
Postcode 5  no
I'd like this done for all 12000 postcodes, without doing it 1 by 1. At the moment, I have to "find"  ctrl f  each postcode from spreadsheet 2, 1 by 1 on spreadsheet 1. Then I have to put manually if it is or isn't on spreadsheet 1 (yes/no)
Game Start Now
 Posts
 138
 Registration date
 Thursday January 21, 2010
 Status
 Member
 Last seen
 May 8, 2019
if they found on sheet1 then what do you want to display in formula cell on sheet2 ?
E
@Game Start Now  I have VLOOKUP on excel already, and I didn't really want to download anything as i'm on a work computer.
Game Start Now
 Posts
 138
 Registration date
 Thursday January 21, 2010
 Status
 Member
 Last seen
 May 8, 2019
This Vlookup Shows You Yes & No If Data Found Or Not.........