Apple Numbers Data Manipulation Function Microsoft Excel vlookup
VLOOKUP
(EXCEL)
Lookup a value in the left most column of a range of cells and return a value from the same row but a different column.
Examples
Lookup value ‘Apple’ and return the quantity or the price
=VLOOKUP(lookup_value, table_array, column_to_return, closest_match)
1) lookup_value : cell A2 – Apple
2) table_array : A2:C4 – area to be included in dataset
(vlookup uses the left most column to search)
3) column_to_return : 2 – Quantity
4) closest_match : false
(only return exact match)
=VLOOKUP(lookup_value, table_array, column_to_return, closest_match)
1) lookup_value : Banana
2) table_array : A2:C4 – area to be included in dataset
(vlookup uses the left most column to search)
3) column_to_return : 3 – Price
4) closest_match : false
(only return exact match)
Link to alternative