Vlookup

[Xeryar]

what is the 12 in this formula . 

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

[#2 · Accepted solution]

@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