Question: how the vlookup function works?
Answer: The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. ... As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet.