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.)