Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup error
Hello,
I've got a Vlookup formula that when I execute it, it totally changes the lookup array. I entered the range "Cusip" as the lookup array in the VBE but it shows up as "CorpA" in the spreadsheet. What am I doing wrong? VBE: Corp.Range("BC4").Resize(DataRow, 1).FormulaR1C1 = "=VLOOKUP(RC[-50]," & Cusip.Address(external:=True, ReferenceStyle:=xlR1C1) & ",3,FALSE) Spreadsheet: =VLOOKUP(E12,CorpA!$A$1:$D$2027,4,FALSE) Thanks, Wes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP #N/A Error | Excel Worksheet Functions | |||
VLOOKUP error | Excel Worksheet Functions | |||
REF# error using VLOOKUP | Excel Worksheet Functions | |||
vlookup error na# | Excel Worksheet Functions | |||
#N/A error with VLOOKUP | Excel Discussion (Misc queries) |