'Vlookup does not return the result on the index number [duplicate]
I am implementing the VLOOKUP in the excel When I use the index 3 it works when I put index 4 it does not return anything .
Both the index has some values. It should return . What could be the problem ?
This is Monthly sheet columns .. it has columns till M
Solution 1:[1]
You table has 3 columns A, B & C, so using 3 picks the result in column 3, but 4 won't exist as there is no column.
You gave the range in Table_Array as Monthly!A:C, so it won't know about any columns after column C as shown in both your images, only one shown here:
So do the correction and put Monthly!A:M then you can address the rest of the columns, until then it will not work.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |