If Formulas

uum6212

New Member
Joined
Dec 16, 2012
Messages
8
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.
 
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
 
Upvote 0
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
 
Upvote 0
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!!
 
Last edited:
Upvote 0
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!
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top