I am using google spreadsheets and the formulas listed in the documents you
linked to still will not give me what I am looking for. Is there a specific
formula you know of that will do it? or could you create one with some info?
I want it to display the text (sheet2 B1:AF1) based on the rankings of
sheet3 B3:B33

"T. Valko" wrote:

See this post in Google Groups:

http://groups.google.com/group/micro...d8708b5?hl=en#

--
Biff
Microsoft Excel MVP


"reeveret" wrote in message
...
I need an if, then formula that will display sheet 2 B1 if sheet3 B3= sheet
2
B32, but I also need it to have a range of displays that if could equal.
Basically I have a sheet of numbers that add up and increase each day for
a
list of stores and I need to rank the totals (which I have done) now that
the totals are ranked, the spreadsheet is displaying the totals (numbers)
ranked and I need it translate those numbers into the title of the cell
they
are the totals for(B1, C1, D1, etc.)