Excel VLOOKUP
VLOOKUP EXPLAINED
Vlookup, hlookup work basically the same but the data is read slightly differently. I ItS
INDEX, a list of things I need, in Column A
DATA, a full list of all columns of data where column B matches the index from A
The actual data I need from DATA is column AA (+26)
paste in the index sheet on column B2, to use A2 as my lookup on DATA
=VLOOKUP(A2, DATA!$B$1:$AA$1000, 26, FALSE)
By use FALSE, my data in INDEX does not need to be sorted and must match exactly.
VLOOKUP EXAMPLE
Main Data List
In the sheet named ALL, I have this data:
| Fruit | Price per Pound |
|---|---|
| Apple | $2.00 |
| Banana | $1.50 |
| Cherry | $3.00 |
| Date | $4.00 |
| Elderberry | $5.00 |
Index
My index sheet, which will be looking up data from the ALL sheet looks like this:
| Fruit | Price per Pound |
|---|---|
| Apple | =VLOOKUP(A2, ALL!$A$1:$B$5, 2, FALSE) |
| Cherry | =VLOOKUP(A3, ALL!$A$1:$B$5, 2, FALSE) |
| Date | =VLOOKUP(A4, ALL!$A$1:$B$5, 2, FALSE) |