help with vlookup in macro
 

Hello everyone,

Anyone know what's wrong with this formula? It's embedded in a macro that
I'm writing.

--
Thanks,
Himansu

help with vlookup in macro
 

here's the formula:


ActiveCell.FormulaR1C1 =
"VLOOKUP(LEFT(rc1,4)&"2"&RIGHT(rc1,LEN(rc1)-5)," & JobNumber &
"_keycodes!R1C1:R150C3,3,FALSE)"


-------




"Himansu" wrote in message
...
Hello everyone,

Anyone know what's wrong with this formula? It's embedded in a macro that
I'm writing.

--
Thanks,
Himansu

help with vlookup in macro
 

Hi,

The 2 between the 2 strings is a bit confusing. I assume you want this

ActiveCell.Formula = "=VLOOKUP(LEFT(rc1,4)" & "&2&" &
"RIGHT(rc1,LEN(rc1)-5)," & JobNumber & "keycodes!R1C1:R150C3,3,FALSE)"


Mike


"Himansu" wrote:

here's the formula:


ActiveCell.FormulaR1C1 =
"VLOOKUP(LEFT(rc1,4)&"2"&RIGHT(rc1,LEN(rc1)-5)," & JobNumber &
"_keycodes!R1C1:R150C3,3,FALSE)"


-------




"Himansu" wrote in message
...
Hello everyone,

Anyone know what's wrong with this formula? It's embedded in a macro that
I'm writing.

--
Thanks,
Himansu

help with vlookup in macro
 

THANKS Mike!!!!!! I was trying to figure this out for the last 2 days....


"Mike H" wrote in message
...
Hi,

The 2 between the 2 strings is a bit confusing. I assume you want this

ActiveCell.Formula = "=VLOOKUP(LEFT(rc1,4)" & "&2&" &
"RIGHT(rc1,LEN(rc1)-5)," & JobNumber & "keycodes!R1C1:R150C3,3,FALSE)"


Mike


"Himansu" wrote:

here's the formula:


ActiveCell.FormulaR1C1 =
"VLOOKUP(LEFT(rc1,4)&"2"&RIGHT(rc1,LEN(rc1)-5)," & JobNumber &
"_keycodes!R1C1:R150C3,3,FALSE)"


-------




"Himansu" wrote in message
...
Hello everyone,

Anyone know what's wrong with this formula? It's embedded in a macro
that
I'm writing.

--
Thanks,
Himansu