I have a spreadsheet with 13 columns and 900 rows (column 1 is zipcodes). I am trying to complete a vlookup that will look at the zip codes in row 14 (I added). Once I receive the matching zipcodes, I need to show the entire rows (Col 1 - Col 13) that has the matching zipcodes. Is vlookup what I should be using along with another formula or should I use another formula?
-
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.
RasGhul
Well-known Member
- Joined
- Jul 15, 2016
- Messages
- 797
- Office Version
- 365
- Platform
- Windows
Index & Match is a much more flexible formula for lookup values, and VLOOKUP won't "look" left. I recommend converting your data to a table so that the formulas are dynamic as you add more zip codes etc.
Assuming that your lookup is on Sheet1 on your data is Sheet2, copy this across(A-M) and down as required;
I started on A2 just in case your first row has Column names.
Assuming that your lookup is on Sheet1 on your data is Sheet2, copy this across(A-M) and down as required;
Code:
=INDEX(Sheet2!A$2:A$900,MATCH(Sheet1!$N2,Sheet2!A$2:A$900,0))I started on A2 just in case your first row has Column names.
Last edited:
Upvote
0
Similar threads
- Question
- Question
