SOLVED

Vlookup

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3163103%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EVlookup%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3163103%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3Ewhat%20is%20the%2012%20in%20this%20formula%20.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3DVLOOKUP(H2%2C'GI%20Claims%20Data'!B%3AN%2C12%2C0)%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3163103%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3163148%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3163148%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1242665%22%20target%3D%22_blank%22%3E%40Xeryar%3C%2FA%3E%26nbsp%3Basked%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%20style%3D%22%20padding-left%20%3A%2030px%3B%20%22%3Ewhat%20is%20the%2012%20in%20this%20formula%20.%26nbsp%3B%3CBR%20%2F%3E%3CSTRONG%3E%3DVLOOKUP(H2%2C'GI%20Claims%20Data'!B%3AN%2C12%2C0)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%20style%3D%22%20padding-left%20%3A%2030px%3B%20%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20the%20answer%20is%20that%20it's%20an%20%22offset%22%20figure.%3C%2FP%3E%3CP%3EThe%20VLOOKUP%20formula%20takes%20a%20value%2C%20(in%20this%20case%20whatever%20is%20in%20cell%20H2)%20goes%20to%20a%20table%20(in%20this%20case%2C%20a%20table%20in%20columns%20B%20through%20N%20of%20tab%20%22GI%20Claims%20Data%22)%20and%20then%20%3CU%3E%3CSTRONG%3Egoes%20to%20the%2012th%20column%3C%2FSTRONG%3E%3C%2FU%3E%20of%20the%20row%20where%20the%20value%20in%20the%20first%20column%20matches%20the%20value%20in%20cell%20H2.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20good%20resource%20for%20understanding%20the%20VLOOKUP%20function%2C%20which%20I%20suspect%20is%20more%20what%20you%20need%20to%20know%2C%20not%20just%20what%20the%2012%20is.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-vlookup-function%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

what is the 12 in this formula . 

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

1 Reply
best response confirmed by Xeryar (Occasional Contributor)
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