Lookup Question

Giganews Newsgroups
Subject: Lookup Question
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!
CB

Replies