Question Locked

V-Look up

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I was wondering if someone can help me. I'm trying to do what i feel should be a simple v-lookup but keep getting an error. So i have a series of data on one page- Zip codes to be exact. On another tab I have additional data: (Zip codes in column A and its correlating city in column B. I need to create a look up that matches the zips to the correct city on the first tab. Any help would be greatly appreciated.

2 replies

by thumbsup2

It should be a simple vlookup. Yes, it should work. But, if you don't tell us what the problem is, we can't help.

Did you sort your lookup data by the lookup column?

This discussion is closed to new replies.