Hello,
I need help to combine a Vlookup and Hlookup and I'm not sure how to do it.
I need to find the value in column A (airport code) on the Results sheet in column B(airport code) on the Zip Code sheet. Then I need to determine if the zipcode in column c on the results sheet is a local zip code to the airport code from the zip code sheet. Any N/A errors are assumed to be Not Local and are omitted from my counts.
I set up an Hlookup in column D on the Results sheet using only the rows that matched the airport code, but I have a list of all the airport codes in the US and a list of local zipcodes for all the airports. Some airports have over 1,000 possible matches that could be local. So it would be ideal to have a formula that combines the H&Vlookup.
I attached sample data to show what I have acheived thus far, but every tutorial I have tried does not work when I try to nest the Hlookup in my Vlookup. Please help!
Naomi
Bookmarks