Help writing a lookup formula

[kgoldner]

Hi

Can you please help me with writing a formula. I am making a bi
comparison sheet for a project that I am building that has 6 differen
elevation combinations Below is a sample of what I am doing with a
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 th
average of that row
The second row C5:N5 are for bids from the second contractor and O5 i
the average of that row
The third row C6:N6 are bids from the third contractor and O6 is th
average of that row

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

Thank You for your help in advance and if you would please email you
response to my email at work (e-mail address removed)

Thanks Kevi

 

[vezerid]

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

Copy accross.

HTH
Kostis Vezerides