Forum Discussion
Vlookup
Xeryar asked
what is the 12 in this formula .
=VLOOKUP(H2,'GI Claims Data'!B:N,12,0)And the answer is that it's an "offset" figure.
The VLOOKUP formula takes a value, (in this case whatever is in cell H2) goes to a table (in this case, a table in columns B through N of tab "GI Claims Data") and then goes to the 12th column of the row where the value in the first column matches the value in cell H2.
Here's a good resource for understanding the VLOOKUP function, which I suspect is more what you need to know, not just what the 12 is. https://exceljet.net/excel-functions/excel-vlookup-function
Xeryar asked
what is the 12 in this formula .
=VLOOKUP(H2,'GI Claims Data'!B:N,12,0)
And the answer is that it's an "offset" figure.
The VLOOKUP formula takes a value, (in this case whatever is in cell H2) goes to a table (in this case, a table in columns B through N of tab "GI Claims Data") and then goes to the 12th column of the row where the value in the first column matches the value in cell H2.
Here's a good resource for understanding the VLOOKUP function, which I suspect is more what you need to know, not just what the 12 is. https://exceljet.net/excel-functions/excel-vlookup-function