View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
reeveret reeveret is offline
external usenet poster
 
Posts: 5
Default Excel formula question...

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