-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VLOOKUP in VBA
- Thread starter SandsB
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,981
- Office Version
- 365
- Platform
- Windows
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
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
Upvote
0
SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 731
- Office Version
- 365
- Platform
- Windows
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),"""")"
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),"""")"
Upvote
0
