naghy

Posts: n/a

Lookup value

I have two colums, one with prices one with quantities

i want to lookup the max quantity and have the price for that quantity shown
in another cell
but the problem is that there are 2 max quantities, so the lookup formula
results in 0

how do i resolve this?

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 Lookup Lookup	MR	Excel Worksheet Functions	2	March 10th 05 01:59 AM
Lookup Function Problem	seve	Excel Discussion (Misc queries)	9	February 28th 05 02:46 AM
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM
Excel Lookup Functions	Paul Adams	Excel Worksheet Functions	1	November 10th 04 02:40 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 01:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us