Reference one column and compare to columns on other worksheets
Closed
dbowley
Posts
3
Registration date
Thursday October 10, 2013
Status
Member
Last seen
October 11, 2013
-
Oct 10, 2013 at 11:38 AM
dbowley Posts 3 Registration date Thursday October 10, 2013 Status Member Last seen October 11, 2013 - Oct 11, 2013 at 10:23 AM
dbowley Posts 3 Registration date Thursday October 10, 2013 Status Member Last seen October 11, 2013 - Oct 11, 2013 at 10:23 AM
Related:
- Reference one column and compare to columns on other worksheets
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- Beyond compare - Download - File management
- Transfer data from one excel worksheet to another automatically - Guide
- How to delete column in word - Guide
2 responses
dbowley
Posts
3
Registration date
Thursday October 10, 2013
Status
Member
Last seen
October 11, 2013
1
Oct 10, 2013 at 12:56 PM
Oct 10, 2013 at 12:56 PM
I essentially want to do an If statement cross referencing the zipcodes from each worksheet to return a value if it is a duplicate or not. But I have a table of the zipcodes that I may need to pull in with a VLOOKUP. I have never used an IF statement with a VLOOKUP inside of it, and I dont even know if that's possible. For example
Main Sheet Table
State 1 State 2 State 3
99999 99999 77777 55555
88888 12121 22222 etc
77777 88888 44444
66666 33333 etc
55555 etc
44444
33333
22222
11111
The main sheet is a list of zips all over the country vs a table that is listed by state with multiple zipsAdd comment - Edit - Link (#2)
Add comment
Main Sheet Table
State 1 State 2 State 3
99999 99999 77777 55555
88888 12121 22222 etc
77777 88888 44444
66666 33333 etc
55555 etc
44444
33333
22222
11111
The main sheet is a list of zips all over the country vs a table that is listed by state with multiple zipsAdd comment - Edit - Link (#2)
Add comment
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 10, 2013 at 12:21 PM
Oct 10, 2013 at 12:21 PM
Dbowley, Good afternoon.
You didn't mention anything about your layout.
Then the only kind of help that I can give you is indicating that you can use VLOOKUP or INDEX + MATCH
I hope it helps.
You didn't mention anything about your layout.
Then the only kind of help that I can give you is indicating that you can use VLOOKUP or INDEX + MATCH
I hope it helps.
dbowley
Posts
3
Registration date
Thursday October 10, 2013
Status
Member
Last seen
October 11, 2013
1
Oct 11, 2013 at 10:23 AM
Oct 11, 2013 at 10:23 AM
I figured it out thanks again!
