Hi,
i can not quite figure out what is wrong with my index/match formula.
I have 1 spreadsheet and trying to index/match from 2 worksheets within the spreadsheet.
Sheet1 has 2 columns
Counties
Zipcodes
Sheet2 has my employee information with zipcodes
id
fname
lname
city
state
ny
county
zipcode
I am trying to populate my County column on Sheet2 with the following formula:
=INDEX(Sheet1!B:B,MATCH(G2,Sheet1!$A$1:$A$2036,0))
My results are coming back with #NA.
Can someone point me in the right direction of what i am doing incorrectly?
Thanks
Sue
i can not quite figure out what is wrong with my index/match formula.
I have 1 spreadsheet and trying to index/match from 2 worksheets within the spreadsheet.
Sheet1 has 2 columns
Counties
Zipcodes
Sheet2 has my employee information with zipcodes
id
fname
lname
city
state
ny
county
zipcode
I am trying to populate my County column on Sheet2 with the following formula:
=INDEX(Sheet1!B:B,MATCH(G2,Sheet1!$A$1:$A$2036,0))
My results are coming back with #NA.
Can someone point me in the right direction of what i am doing incorrectly?
Thanks
Sue