Aug 12 2022 04:03 AM
Aug 12 2022 04:09 AM
Aug 12 2022 04:11 AM
VLOOKUP searches for the lookup value (A2) in the first column of the lookup range (i.e. Sheet1 column A). If it finds a match, it returns the value from the column of the lookup range specified in the 3rd argument. In your example, the column index is 2, so it would return a value from Sheet1 column B.
Aug 12 2022 04:43 AM
Searching the entire sheet has a terrible impact on performance. In the following, I used A1:AJ100.
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.