Excel VLookup Results

ladybean

New Member
Joined
Jun 17, 2018
Messages
1
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?
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
609
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;

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:

Watch MrExcel Video

Forum statistics

Threads
1,108,730
Messages
5,524,491
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top