How to do a Vlookup in Excel?

VLOOKUP is an excel formula which helps us looking for the data in the tables. To use it properly we need to have the proper table containing the data (1) and know the syntax for the formula (2).

vlook tricks

vlook

(1) Table containing the data

Name                      Favourite Animal                     Favourite food
Russ                                   ibex                                                   beets
Scottie                              pronghorn                                          figs
Kirstin                             prairie dog                                        waffles
Mandi                              mole crab                                           cakes
Jewel                                wombat                                            tomatoes
Candida                           sloth                                                    crepes
Frieda                              mink                                                    olives
Lindsey                            hedgehog                                          croissant
Jacinto                             fox                                                         garlic
Malia                                 raccoon                                             apple pie

(2) Syntax for the formula: VLOOKUP(value, table range, column number, 1/0)

VALUE is the string or amount we will be looking for IN THE FIRST COLUMN of the table
TABLE RANGE is the table we want to look for the data in
COLUMN NUMBER is the number of the column from which we would like to pull
the data referring to the VALUE we selected
1/0 if we want to find the EXACT VALUE in the first column, we have to type “0”,
if we put” 1″ the excel will look also for similar VALUES, works best with numbers

Example

VLOOKUP(“Kirstin”, B5:D15, 3,0)

Look for the exact word “Kirstin” in the first column of the table starting in B5 ending in D15.
From the row where the word “Kirstin” is found, move to the third column (B is first, C is second, D is third)
Return the value from that cell

Kirstins favourtie food waffles <- formula here

VLOOKUP(“Frieda”, B5:D15, 2,0)

Look for the word “Frieda” in the first column of the table starting in B5 ending in D15.
From the row where the word “Frieda” is found, move to the second column (B is first, C is second, D is third)
Return the value from that cell

Friedas favourtie animal mink <- formula here

Notes

NOTES:
1. Vlookup can only search by the leftmost column. For example we cant search for the name by inputting
the favourite animal and giving the negative column number.
2. We can search not only by inputting the value manually, we can also use the cell address.

VLOOKUP(“Russ”, B5:D15, 2,0) ibex <- formula here ibex <- formula here

Leave a Reply

Your email address will not be published. Required fields are marked *