Question: why is vlookup used in excel sheets?
Answer: VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP. ... value - The value to look for in the first column of a table.