Posted to microsoft.public.excel.misc

Chris_t_2k5

Posts: n/a

Lookup an array

Hi, I require a formula that will answer the following problem.

I have cells A1:D100 full of data and these are my reference cells.

I also have cells F1:H50 full of data.

What I require is a lookup formula that will lookup cells F1:H1, F2:H2 etc
compared with cells A1:C100 and if all of the 3 cells are matched then return
the corresponding value from column D.

Thanks

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
Lookup "greater than or equal to" in lookup array	icemouse	New Users to Excel	3	February 16th 06 10:07 PM
Lookup array?	HBj	Excel Worksheet Functions	2	January 4th 06 02:47 PM
How do I lookup a value in a array that is not in ascending order	John	Excel Worksheet Functions	6	June 20th 05 09:40 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM

All times are GMT +1. The time now is 09:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us