if statements

[Peter]

I need some help or pointing in the right direction



I'm using Excel 2003



I'm using "if statements" but the maximum i can use is 7. i need to use
quite a few more now. What's the best way to over come this?

 

[Don Guillett]

Several. Try looking in the help index for VLOOKUP

 

[Bob Phillips]

Depends upon the problem. Expand on the detail.

 

[Peter]

Cheers for your reply

A B C
Customer Item Part No

i'm using if statement to auto enter the part number,
so if enter customer in col A & Item in col B the part number is
automatically generated.

 

[Dave Peterson]

Are the item numbers the same no matter what the customer is?

If yes, then it sounds like a =index(match()) would work.
Debra Dalgleish shows how to use a two dimensional table here:
http://contextures.com/xlFunctions03.html#IndexMatch2

If the item numbers are not the same across customers, you could build a table
and use the instructions here:
http://contextures.com/xlFunctions03.html#IndexMatch4

That whole page is worth reading.