Hi Maggie,

Look he

http://www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Maggie" wrote in message ...
|I have a spreadsheet to keep track of sales tax information. I have a drop
| down list in the first column to choose the customer, and I want the next
| several columns to fill in automatically with the customer's address and some
| other information. I did fine with a nested IF formula until I reached the
| limit of 7. We have more than 7 customers who we charge sales tax, and I need
| to hit them all somehow