Advanced VLOOKUP in Excel: multiple, double, nested
WEBMar 22, 2023 · For this example, we'll take the below table with monthly sales and work out a VLOOKUP formula to retrieve the sales figure for a specific item in a given month. With item names in A2:A9, month names in B1:F1, the target item in I1 and the target month in I2, the formula goes as follows: =VLOOKUP(I1, A2:F9, MATCH(I2, A1:F1, 0), FALSE)