Ron Coderre

Posts: n/a

To return the name of the high bidder (using my previous example) put this
formula in cell F1:
=INDEX($B$1:$B$7,MATCH(E1&D1,($A$1:$A$7)&($C$1:$C$ 7),0))

(Note: Commit that array formula by pressing [Ctrl]+[Shifr]+[Enter])

Then copy it down to Cells F2 and F3

I hope that helps.

Regards,
Ron

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
How do I return dynamic lists?	liciakay	Excel Worksheet Functions	1	March 30th 05 08:22 AM
If (either of these) return this	taxmom	Excel Worksheet Functions	6	March 29th 05 09:15 PM
Return lowest quantity	Pat	Excel Worksheet Functions	2	March 8th 05 09:59 PM
Can VLOOKUP return multiple answers based on several identical lo.	jddtct	Excel Worksheet Functions	3	January 11th 05 07:03 AM
Return the smallest value	Donkey	Excel Worksheet Functions	2	December 24th 04 10:10 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us