How do I have a data table display cell names rather than values?

G

Guest

I am trying to run some sensitivity analysis on an aggrregate score from a
listing of rankings. The rankings are a product of the rankings in different
attributes and two attributes also have a beta integrated into them. My goal
is to run a sensitivity analysis using a data table. Currently i have a
conditional statement if(max(A3:A66)=A3, "Chicago",
if(max(A3:A66)=A4,"Cincinnati" and so on. Unfortunately I can only do that 12
times, meaning some cells in my 11x11 data table are left blank because I can
not cover them in those tweleve names. The other option I have tried is a
simple MAX function but it only returns values. My question is how do get the
data table to record the name of the cell instead of the value?
 
G

Guest

Put the City names into cells B3:B66 then use

=vlookup(max(a3:a66),A3:B66,2,FALSE)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to assign values to a cell based on values in another cell? 1
Conditionally format a cell using a list of data defined in a rang 2
How can I do a lookup to a specific cell on another tab 1
How do I add sequential numbers to existing data in excel? 3
finding values in a table using 2 criteria (changed) 3
Pivot Table question or a simpler suggestion 2
Whatsthe formula which retrieves a # from a multiplication table 4
Cell reference to make a directory path 10

Top