Just the thing for VLOOKUP.
Read Help; buy a book; experiment; come back when you have tried
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Maggie" wrote in message
...
Basically using it to fill in info from another sheet. Ex:
IF(b9=customer1,customer1 address,IF(b9=customer2,customer2
address.....etc.

I don't really get how VLOOKUP and HLOOKUP work.

"Duke Carey" wrote:

You need to use the VLOOKUP() function, or perhaps the HLOOKUP()
function.

You're not specific about how you are using the IF()s, but one of the
lookup
variants should give you what you want.

You might also explore MATCH() and INDEX()


"Maggie" wrote:

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