STOP Using Vlookup NOW #exceltips #vlookup

The formula VLOOKUP($C$13,$C$2:$F$10,{2,3,4},0) is using the VLOOKUP function to look up a value in a table and return corresponding values from multiple columns.

Here’s the breakdown:

$C$13: This is the value to look up. The dollar signs ($) indicate an absolute reference, meaning the cell won't change if the formula is copied to another location.

$C$2:$F$10: This is the lookup range (the table) where the VLOOKUP will search for the value from C13. The search will be done in the first column (column C) of this range.

{2,3,4}: This is an array of column indexes to return results from.

2 refers to the 2nd column of the range (D),
3 refers to the 3rd column (E),
4 refers to the 4th column (F).
So, VLOOKUP will return values from these columns when a match is found.

0: This specifies an exact match. VLOOKUP will return a result only if it finds a value in the first column of the range (C) that exactly matches the value in C13.

What Happens:
VLOOKUP searches for the value in cell C13 within the first column (C) of the range $C$2:$F$10.
When it finds a match, it retrieves the corresponding values from columns 2 (D), 3 (E), and 4 (F).
Since {2,3,4} is an array, the formula will return an array of results from those columns.
This type of array-based VLOOKUP works in Excel versions that support dynamic arrays (Excel 365, Excel 2021).

#learnexcel