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
2
3
4

<TBODY>
[TD="bgcolor: #ffff00"]12
[/TD]

[TD="align: right"][/TD]
[TD="bgcolor: #ffff00"]730A-8P
[/TD]

[TD="align: right"][/TD]
[TD="bgcolor: #ffff00"]8
[/TD]

[TD="align: right"][/TD]
[TD="bgcolor: #ffff00"]D
[/TD]

</TBODY>

Sheet1​

Excel 2007

	B	C
1	Result
2
3
4

<TBODY>
[TD="bgcolor: #ffff00"]730A-8P
[/TD]

[TD="align: right"][/TD]
[TD="bgcolor: #ffff00"]730A-8P
[/TD]

[TD="align: right"][/TD]
[TD="bgcolor: #ffff00"]730A4P
[/TD]

[TD="align: right"][/TD]
[TD="bgcolor: #ffff00"]D
[/TD]

</TBODY>

Sheet2​

[TABLE="width: 85%"]
<TBODY>[TR]
[TD]Worksheet Formulas
[TABLE="width: 100%"]
<TBODY>[TR="bgcolor: #e0e0f0"]
[TH="width: 10"]Cell
[/TH]
[TH="align: left"]Formula
[/TH]
[/TR]
[TR]
[TH="width: 10, bgcolor: #e0e0f0"]C1
[/TH]
[TD="align: left"]=IF(Sheet!C1="","", IF(Sheet1!C1=12,"730A-8P",IF(Sheet1!C1=8,"730A4P",Sheet1!C1)))
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
</TBODY>[/TABLE]

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!