Excel 2003 SP3 formula help needed

[Snookless7]

Hi,

Thank you in advance.

I created a spreadsheed on my MAC Book which contained a formula in one of the columns as follows:

=IF(J24="vc",1,IF(J24="vcx2",2,IF(J24="vcx3",3,IF(J24="vcx4",4,IF(J24="hc",5,IF(J24="hcx2",6,IF(J24="hcx3",7,IF(J24="hcx4",8,IF(J24="din",9,IF(J24="vd",10,IF(J24="mc",11,IF(J24="mcx2",12,IF(J24="mcx3",13,IF(J24="mcx4",14,IF(J24="mcd",15," ")))))))))))))))

for lack of knowledge I could not think of a shorter way to do this.


I put the file on my PC with excel 2003 SP3 and it says that "the formula has more levels of nesting that are allowed in this version of excel", then the formula is converted to a "#Value" errors.


From looking at thise formula is there a different way I can achieve the same logic with less nesting?

Thank you again.

Snookless7

 

[SkipVought]

Hi,

Build a Lookup Table...
[tt]
LUV Val
vc 1
vcx2 2
vcx3 3
...
[/tt]
Then use VLOOKUP


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Snookless7]

Skip,

Thank you very much.

Since I am really not that good with this as you have prob guessed I had to google "how to create a Vlookup".....I got it and it worked!

Thank you very much!


Todd

 

[SkipVought]

If you use your F1 key in Excel, you don't need to google as much.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Snookless7]

Again..Much appreciated.
Thank you.