display cell name or label as formula result

  • Thread starter Thread starter kproctor
  • Start date Start date
K

kproctor

Help please,

Is there a way to display the cell name or label as the formula result
as opposed to the value of the calculation?

example:

=MAX(CAT,DOG,BIRD)

The value is of CAT is 25.00%. Can the result displayed be CAT instea
of 25.00%?



Any help is greatly appreciated, thank you
 
k,

I can't be sure what you're starting with. Do you have a table listing the
values of these "names," or are they really named cells?
 
k,

It could probably be done with a macro.

How about a table of these:

Table:
25% Cat
60% Dog
15% Bird

Then wrap it in your formula with a VLOOKUP:

=VLOOKUP(MAX(Cat, Dog, Bird), Table, 2)
 
Back
Top