Related:
- Comparing data on 2 spredsheets
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- Red dead redemption 2 free download - Download - Action and adventure
11 responses
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Sep 3, 2010 at 05:48 AM
Sep 3, 2010 at 05:48 AM
=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
7
Sep 2, 2010 at 11:27 AM
Sep 2, 2010 at 11:27 AM
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
26
Sep 2, 2010 at 07:24 PM
Sep 2, 2010 at 07:24 PM
This could be achieved by using VLOOKUP. There are many recent examples of this in this forum.
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)
Didn't find the answer you are looking for?
Ask a question
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Sep 3, 2010 at 04:36 AM
Sep 3, 2010 at 04:36 AM
if they found on sheet1 then what do you want to display in formula cell on sheet2 ?
@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
7
Sep 3, 2010 at 05:46 AM
Sep 3, 2010 at 05:46 AM
This Vlookup Shows You Yes & No If Data Found Or Not.........
Game Start Now
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
Sep 3, 2010 at 06:13 AM
Sep 3, 2010 at 06:13 AM
thats why i put that formula on my sample sheet which i upload.