Posted to microsoft.public.excel.worksheet.functions

Bob S

Posts: n/a

LOOKUP question

Is it possible to have LOOKUP do a calculation in the array part instead of
just displaying the values in the array? As in
=LOOKUP(G24,{1,2,3},{C1+C2,D1+D2,E1+E2})

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
Newbie and use of lookup question?	manasi	Excel Discussion (Misc queries)	6	September 21st 05 01:03 PM
Lookup formula question	PeterG	Excel Discussion (Misc queries)	3	July 13th 05 02:26 PM
Lookup question	Ntisch	Excel Discussion (Misc queries)	4	June 27th 05 07:00 AM
Lookup Question	Brad P	Excel Worksheet Functions	3	June 5th 05 12:08 AM
Lookup Question	Mackay 1979	Excel Worksheet Functions	2	February 19th 05 01:11 PM

All times are GMT +1. The time now is 08:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us