Help with OFFSET function

  • Thread starter Thread starter David R
  • Start date Start date
D

David R

Being a newcomer to functions and Using Excel 97, I have
set up a spread sheet as follows:

Columns A, C and E contain the names of companies and
columns B, D and F contain quotations that were received
from the companies in columns A, C and E respectively.
Cell G1 has the following formula:

=MIN(B1,D1,F1)

I tried to populate cell H1 with the name that corresponds
to the MIN value in column G by using the following
formula:

=OFFSET(MIN(B1,D1,F1),0,-1,1,1)

but, alas, an error message. Am I going about this the
wrong way?

TIA
David
 
Hi David
i would set-up your file differently:
- use column A for the company names
- use column B for the associated quotes

Now use the following formulas:
C1:
=MIN(B1:B10)
D1:
=INDEX(A1:A10,MATCH(C1,B1:B10,0))
 
You could do it a couple of ways. Here's one:

=INDEX(A1:F1,MATCH(MIN(A1:F1),A1:F1,0)-1)

HTH
Jason
Atlanta, GA
 
To clarify, I work in a construction company. Row 1
contains quotations for excavation, row 2 contains
quotations for concrete forming, etc. Populating the rows
(B1:B10)with the quotations defeats my purpose.

David
 
This did the trick, Thanks a lot!!

David
-----Original Message-----
You could do it a couple of ways. Here's one:

=INDEX(A1:F1,MATCH(MIN(A1:F1),A1:F1,0)-1)

HTH
Jason
Atlanta, GA

.
Click to expand...
 
Back
Top