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


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

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


"kgoldner" wrote:

>
> 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.
> Thanks Kevin
>
>
> --
> kgoldner
> ------------------------------------------------------------------------
> kgoldner's Profile: http://www.hightechtalks.com/m715
> View this thread: http://www.hightechtalks.com/t2331809
>
>

Hi!

Enter this formula in C8 and copy across to N8:

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

Biff

"kgoldner" <kgoldner.21l9xy@no-mx.forums.yourdomain.com.au> wrote in message
news:kgoldner.21l9xy@no-mx.forums.yourdomain.com.au...
>
> 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.
> Thanks Kevin
>
>
> --
> kgoldner
> ------------------------------------------------------------------------
> kgoldner's Profile: http://www.hightechtalks.com/m715
> View this thread: http://www.hightechtalks.com/t2331809
>

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

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


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

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

"kgoldner" <kgoldner.21li9z@no-mx.forums.yourdomain.com.au> wrote in message
news:kgoldner.21li9z@no-mx.forums.yourdomain.com.au...
>
> I tried this formula but the NAME error came back when entered
>
> =INDEX($C4:$N6,MATCH($O8,$O4:$O6,0),COLUMN(A:A))
>
>
> --
> kgoldner
> ------------------------------------------------------------------------
> kgoldner's Profile: http://www.hightechtalks.com/m715
> View this thread: http://www.hightechtalks.com/t2331809
>