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?

Several. Try looking in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Peter" wrote in message
...
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?

Depends upon the problem. Expand on the detail.

--
__________________________________
HTH

Bob

"Peter" wrote in message
...
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?

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.


"Bob Phillips" wrote in message
...
Depends upon the problem. Expand on the detail.

--
__________________________________
HTH

Bob

"Peter" wrote in message
...
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?

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 he
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 he
http://contextures.com/xlFunctions03.html#IndexMatch4

That whole page is worth reading.

Peter wrote:

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.

"Bob Phillips" wrote in message
...
Depends upon the problem. Expand on the detail.

--
__________________________________
HTH

Bob

"Peter" wrote in message
...
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?







--

Dave Peterson