Vlookup

A spreadsheet term. Short for 'Vertical Lookup'.

In spreadsheets it is very common to want to 'look up' one thing against another. For example, you may want to look up the price of a certain product.

This what a vlookup function does - it allows you to find a value within a table given the matching description in the left-most column of the table:

 

A

B

1

APPLE

20.0

2

PEAR

1.0

The formula looks like this =VLOOKUP("APPLE", A1:B2, 2) and the answer it returns is 20.0

The A1:B2 is the 'range' of the lookup table.


Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: VLOOKUP

2020-10

back to glossaryback to glossary