Help writing a lookup formula
 

Hi

Can you please help me with writing a formula. I am making a bid
comparison sheet for a project that I am building that has 6 different
elevation combinations Below is a sample of what I am doing with an
explanation of what I need. This is the cell layout:

C4 D4 E4 F4 G4 H4 I4 J4 K4 L4 M4 N4 O4
C5 D5 E5 F5 G5 H5 I5 J5 K5 L5 M5 N5 O5
C6 D6 E6 F6 G6 H6 I6 J6 K6 L6 M6 N6 O6

C8 D8 E8 F8 G8 H8 I8 J8 K8 L8 M8 N8 O8

The first row C4:N4 are bids from the first contractor and O4 is the
average of that row
The second row C5:N5 are for bids from the second contractor and O5 is
the average of that row
The third row C6:N6 are bids from the third contractor and O6 is the
average of that row

O8 is the minimum of the 3 averages which will be my contractor. Now I
need a formula for each cell C8 thru N8 to look up O8 cell to find the
low bidder and than place the bid from the appropriate column from that
low bidder into the C8:N8 cells.

Thank You for your help in advance and if you would please email your
response to my email at work

Thanks Kevin


--
kgoldner
------------------------------------------------------------------------
kgoldner's Profile: http://www.hightechtalks.com/m715
View this thread: http://www.hightechtalks.com/t2331593

Help writing a lookup formula
 

Kevin,
In C8:
=INDEX(C4:C6, MATCH($O8,$O4:$O6,0))

Copy accross.

HTH
Kostis Vezerides