Posted to microsoft.public.excel.programming

external usenet poster

Posts: 48

Problem with Lookup-function

Sub test()
Cells(3, 3).FormulaR1C1 = "=sum(R1C1:R5C1)" 'Succees
Cells(4, 3).Value = "LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Succees
Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)" 'Error
End Sub

VBA in Excel 2002. Two first lines succees, but the third one gives error
'Runtime error 1004: Application or object defined error'. What's wrong with
the third row?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
problem with LOOKUP function	Boston_north	Excel Discussion (Misc queries)	2	March 23rd 09 02:28 PM
LOOKUP function Problem	justme	Excel Worksheet Functions	2	December 13th 06 04:40 AM
LOOKUP function problem?	DORI	Excel Worksheet Functions	0	November 27th 05 11:45 PM
Lookup function problem (kg)	greencecil	Excel Worksheet Functions	3	July 1st 05 04:54 PM
problem lookup function	bill gras	Excel Worksheet Functions	2	June 22nd 05 03:57 PM

All times are GMT +1. The time now is 10:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us