Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup-function does not work
I have a simple VBA sub:
sub test Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" end sub Result is error ('Run-time error '1004': Application-defined or object defined error'). Is this Excel-bug or am I missing something? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup-function does not work
your syntax is incorrect. Please read HELP on spreadsheet functions
Cells(1, 1).FormulaR1C1 = "=LOOKUP( 3 , R1C2:R5C2 ,R1C3:R5C3 )" separate using commas in this example the value 3 is looked up in the range B1:B5 and the match in C1:C5 ( the 2nd column of t he range) is returned "SamMy" wrote: I have a simple VBA sub: sub test Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" end sub Result is error ('Run-time error '1004': Application-defined or object defined error'). Is this Excel-bug or am I missing something? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup-function does not work
Thanks.
"Patrick Molloy" kirjoitti: your syntax is incorrect. Please read HELP on spreadsheet functions Cells(1, 1).FormulaR1C1 = "=LOOKUP( 3 , R1C2:R5C2 ,R1C3:R5C3 )" separate using commas in this example the value 3 is looked up in the range B1:B5 and the match in C1:C5 ( the 2nd column of t he range) is returned "SamMy" wrote: I have a simple VBA sub: sub test Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" end sub Result is error ('Run-time error '1004': Application-defined or object defined error'). Is this Excel-bug or am I missing something? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
how do I get lookup to work | Excel Worksheet Functions | |||
Lookup Doesn't Work | Excel Worksheet Functions |