View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TL TL is offline
external usenet poster
 
Posts: 10
Default IF or VLOOKUP or whatever

I have a spreadsheet using IF statement but now find I am limited to 7
statements max. Here is what I have. A=City another tab (RATES) on
spreadsheet breaksdown rates based on cities. I need : Find the rate that
applies to the city listed. There are 12 Cities then an all other rate for
cities not listed. I know this can be done, but I just can't figure it out.

Thanks
--
TL Fitz