Reference one column and compare to columns on other worksheets

[Closed]
Report
Posts
3
Registration date
Thursday October 10, 2013
Status
Member
Last seen
October 11, 2013
-
Posts
3
Registration date
Thursday October 10, 2013
Status
Member
Last seen
October 11, 2013
-
I am trying to compare zipcodes from other worksheets compared to the main worksheet to return a true or false value. Help please!

2 replies

Posts
3
Registration date
Thursday October 10, 2013
Status
Member
Last seen
October 11, 2013
1
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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.
Posts
3
Registration date
Thursday October 10, 2013
Status
Member
Last seen
October 11, 2013
1
I figured it out thanks again!