ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Coding in VLOOKUP function (https://www.excelbanter.com/excel-programming/287780-coding-vlookup-function.html)

JC[_8_]

Coding in VLOOKUP function
 
I am trying to use a VLOOKUP function within a macro. The
code I am currently attempting to use is:
VLOOKUP(RC3,'LMon & " CF"'!R8C3:R260C27,'LMon & " CF"'!R[4]
C[11],0)

where LMon is a defined variable that holds name of the
previous month. For example "Dec CF" is one of the sheets
in my workbook.

With the syntax above I am getting a Compile Error. Can
someone tell me how this shuld be correctly written.

TIA,
JC


All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com