If Formulas

[uum6212]

Hello everyone, I'm new to this website and need some assistance. My "IF" formulas are too long and won't work due to nesting? This is the formula I have came up with. =IF(ISNUMBER(SEARCH("12",SHEET1!A1)),"730A-8P",IF(ISNUMBER(SEARCH("8",SHEET1!A1)),"",))) but if I don't have a 12 or an 8 I just want the cell sheet2 a1 to match the text sheet1!a1. Thank you for you help.

 

[uum6212]

Snakehips,

IF Sheet1 A1=12 then Sheet2 A1=730a-8p
IF Sheet1 A1=8 then Sheet2 A1=730a-4p
IF Sheet1 A1= anything else then Shee2 A1=A1

 

[uum6212]

Snakehips,

Correct

If Sheet1!A1 = 12 then Sheet2!A1 = 730a-8p
If Sheet1!A1 = 8 then Sheet2!A1 = 730a-4p
If Sheet1!A1 = any of the following 7a-330p, 730a-330p, 730a-8p, 12p-830p, 1130a-8p, 1130a-12a, 330p-12a, 745p-745a, 1145a-745a, D, then sheet2!A1 = Sheet1!A1

 

[Snakehips]

UUM6212,

Then.................
Excel 2007

	B	C
1	Data	12
2		730A-8P
3		8
4		D

<TBODY>
</TBODY>

Sheet1​

Excel 2007

	B	C
1	Result	730A-8P
2		730A-8P
3		730A4P
4		D

<TBODY>
</TBODY>

Sheet2​

Worksheet Formulas Cell Formula C1 =IF(Sheet!C1="","", IF(Sheet1!C1=12,"730A-8P",IF(Sheet1!C1=8,"730A4P",Sheet1!C1))) <TBODY> </TBODY>

<TBODY>
</TBODY>

I would still advise you consider data validation in sheet 1

Hope that sorts it!!

 

[uum6212]

Snakehips,

Thank you very much! This is only my second day learning functions on excel. I'v got alot to learn. But with every little thing I learn I make sure I document and copy for a reference. Your help is much appreciated.

Thanks,

uum6212

P.S- that worked out my friend!