THE education site for computer science and ICT
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