Posted to microsoft.public.excel.misc

F. Lawrence Kulchar F. Lawrence Kulchar is offline

external usenet poster

Posts: 124

LOOKUP worksheet function

Why does:

=LOOKUP(1.00001,--{"1";"1:"})

return a value of 0.0417 ??

Thanks,

FLKULCHAR

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
lookup for worksheet	Bradrok	Excel Worksheet Functions	1	April 2nd 08 11:04 PM
Worksheet Rank / Lookup function	Gary T	Excel Worksheet Functions	4	October 26th 07 07:14 PM
how to combine an IF Function with a lookup function to determine	[email protected]	Excel Worksheet Functions	1	December 5th 06 06:09 AM
Worksheet lookup	Greg B	Excel Discussion (Misc queries)	2	August 4th 05 12:47 PM
Pivot table doing a lookup without using the lookup function?	NGASGELI	Excel Discussion (Misc queries)	0	August 2nd 05 05:08 AM

All times are GMT +1. The time now is 07:25 PM.

About Us

"It's about Microsoft Excel"