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