|Posted by:||Charlie Brandon (cbrand…@plateautel.net)|
|Date:||Fri, 28 May 2004|
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!