hi my name is Ho
#google sheets vlookup
How to use excel vlookup
This function(vlookup) is also available in Google Sheets.
Use VLOOKUP when you need to find an item by row in a table or range. For example, find the price of a car part by part number or find an employee's name based on their ID.
=vlookup (comparison value, original value, 2 above the position of the cell to retrieve the value)
Comparison value = A character that can be compared to see if the comparison string is from the original value.
Original value = All areas of the original value are required. You can think of it as DB.
Last number = A number that determines which row to import.
0 Comments