Lookup Question

  • Thread starter Thread starter Charlie Brandon
  • Start date Start date
C

Charlie Brandon

I have a list of contractors in column 1 and their bid price in column 2. Is
there a way to use one of the "lookup" functions (or any other function) to
show the low bid contractor and their qoute in a pair of cells located at
the top of my worksheet without having to sort the list? In one header cell,
I'm using =MIN() to determine the lowest bid price, but I can't seem to link
the matching contractor with his bid.

Any suggestions would be greatly appreciated!
CB
 
One way

=INDEX(A2:A50,MATCH(MIN(B2:B50),B2:B50,0))

where A2:A50 are the contractors and B2:B50 their bids

you can also use autofilter and select top 10 from the dropdown in
the bid column and change from top to bottom.. Or using a formula

=INDEX($A$2:$A$50,MATCH(SMALL($B$2:$B$50,ROW(1:1)),$B$2:$B$50,0))

copy down 5 rows



--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top