if statements
 

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?

if statements
 

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?

if statements
 

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?

if statements
 

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?

if statements
 

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