SOLVED

Vlookup

Occasional Contributor

Vlookup

what is the 12 in this formula .

=VLOOKUP(H2,'GI Claims Data'!B:N,12,0)

best response confirmed by Xeryar (Occasional Contributor)
Solution

Re: Vlookup

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