Help typing 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.
Thanks Kevi

 

[Elkar]

I have a couple suggestions for you.

First off, rather than creating a summary line showing the lowest bidder,
you could use Conditional Formatting to highlight the row of the lowest
bidder. This would also give you the advantage of seeing 2 bidders in the
event of a tie. A summary line would not show this.

My second suggestion would be to move your Averages column to the beginning
of your data (column C) and then use the VLOOKUP function to find your
results.

If you need help with either of these, post back.

HTH,
Elkar

 

[Biff]

Hi!

Enter this formula in C8 and copy across to N8:

=INDEX($C4:$N6,MATCH($O8,$O4:$O6,0),COLUMN(A:A))

Biff

 

[kgoldner]

I tried this formula but the NAME error came back when entered

=INDEX($C4:$N6,MATCH($O8,$O4:$O6,0),COLUMN(A:A)

 

[Biff]

I have no idea why that would return #NAME?.

As long as the functions were spelled correctly there's no reason for it to
return #NAME?.

Got me?????????

Biff