VLOOKUP in VBA

[SandsB]

Brain dead.
What cells do the numbers -31, -15, -6 and 18 represent in this?
"=IFNA(VLOOKUP(RC[-31],'DataFile'!R2C[-15]:R200C[-6],18,FALSE),"""")"

 

[Joe4]

Read this article here for R1C1 range references: An Ultimate Guide To Learn R1C1 Reference Style in Excel

Note that "18" is the 3rd argument of the VLOOKUP function, which says return the value from the 18th column in your lookup range.
Excel has extensive documentation on all their functions. You can find good details and examples with a Google search.
See: VLOOKUP function - Microsoft Support

 

[SandsB]

Really brain dead. My active cell is at Q2 in one sheet, Report, and the VLOOKUP is on another, DataFile. In Report, the value of cell B2 is the one I want to lookup in range B2:S200 of DataFile. The value I'm search for is in column R.
This is the formula for that when I'm not using VBA: =VLOOKUP(B2,'DataFile'!A2:S200,18).
I'm nowhere near column 31 which makes me totally lost so what do those numbers specifically refer to? "=IFNA(VLOOKUP(RC[-31],'DataFile'!R2C[-15]:R200C[-6],18,FALSE),"""")"