Cell references - HELP!!!!
 

If someone could help me, I would really appreciate it! I am using the LARGE
function to return certain values from a list of numbers. For example, I
have the following data:
JAN 100
FEB 150
MAR 200
APR 175
MAY 180
In part of a spreadsheet, I have LARGE(($B$10:$B$14),1) which returns the
highest value, 200. What I am trying to do next is have data from the
corresponding row be returned. For example, I want MAR returned in the cell
next to the LARGE formula above. I tried to do this by turning on the R1C1
function, and inserting the formula into the reference, but it is taking the
result as the row, not using the result's row as the reference. (is that a a
tongue twister?)
Anyway, if someone could tell me how to do this, it would save me hours of
manually inserting data!!!!
Thanks to any who take the time to respond!!
--
Shirley

This could be done using a VLOOKUP. But how do you handle 2 months
having exactly the same number? If MAR and APR were both 200, what do
you do? The answer will determine how to resolve the overall question.

=INDEX(A10:A14,MATCH(MAX(B10,B14),B10:B14,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shirley" wrote in message
...
If someone could help me, I would really appreciate it! I am using the
LARGE
function to return certain values from a list of numbers. For example, I
have the following data:
JAN 100
FEB 150
MAR 200
APR 175
MAY 180
In part of a spreadsheet, I have LARGE(($B$10:$B$14),1) which returns the
highest value, 200. What I am trying to do next is have data from the
corresponding row be returned. For example, I want MAR returned in the
cell
next to the LARGE formula above. I tried to do this by turning on the
R1C1
function, and inserting the formula into the reference, but it is taking
the
result as the row, not using the result's row as the reference. (is that a
a
tongue twister?)
Anyway, if someone could tell me how to do this, it would save me hours of
manually inserting data!!!!
Thanks to any who take the time to respond!!
--
Shirley

If more than one month has the same value, I would want it to list the latest
month.
I think I misunderstood the VLOOKUP function. I thought it returned a cell
reference, not a value in the cell??
--
Shirley


"Dave O" wrote:

This could be done using a VLOOKUP. But how do you handle 2 months
having exactly the same number? If MAR and APR were both 200, what do
you do? The answer will determine how to resolve the overall question.

Thanks!!!!!
--
Shirley


"Bob Phillips" wrote:

=INDEX(A10:A14,MATCH(MAX(B10,B14),B10:B14,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Shirley" wrote in message
...
If someone could help me, I would really appreciate it! I am using the
LARGE
function to return certain values from a list of numbers. For example, I
have the following data:
JAN 100
FEB 150
MAR 200
APR 175
MAY 180
In part of a spreadsheet, I have LARGE(($B$10:$B$14),1) which returns the
highest value, 200. What I am trying to do next is have data from the
corresponding row be returned. For example, I want MAR returned in the
cell
next to the LARGE formula above. I tried to do this by turning on the
R1C1
function, and inserting the formula into the reference, but it is taking
the
result as the row, not using the result's row as the reference. (is that a
a
tongue twister?)
Anyway, if someone could tell me how to do this, it would save me hours of
manually inserting data!!!!
Thanks to any who take the time to respond!!
--
Shirley