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.