First time poster and would appreciate some help. I have a spreadsheet with all zip codes, cities, st, etc for New England and New York. I want to be able to pull data by entering a city name. But cities like Springfield, Albany, etc are in multiple states. So I thought I can use range names for each states date. Ex @vlookup(A2,NY,4) where Albany is entered in A2. That I want the flexibility of entering the state in B2 and use a formula @Vlookup(A2,B2,4) where it searches for Albany in New York but that doesn't work. For the array how do I have it go to a cell and then use the named range identified by what's in that cell? I tried @ABS(B2) but that didn't work. Thanks in advance!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
@Vlookup Excel 2007
- Thread starter DarrylR
- Start date
Thank you Fluff. I greatly appreciate the help. I have used excel for years and never stumbled on INDIRECT. Big Thumbs Up!!
Upvote
0
