IF and OR Formula

weaselmcguff

Board Regular
Joined
Feb 24, 2006
Messages
246
Trying to figure out how to do this.

In A1 they are selecting what they are converting FROM
in B1 they are selecting what they are going TO
underneath each box it will show what makes up that kit they selected above it.

In C2:C10 it will show them what they need to order

I am trying to write the formula to where

If in B3 = PartB then you need it automatically for C3, even if it is in A3. But if it is not PartB and it is different than A3 you need it.
If A2=B2 then yu need nothing
if A2 does not equal B2 then you need what is in B2
I want the end result to look similar to what i have below
KIT1KIT2Need
PartAPartA
PartBPartBPartB
PartCPartDPartD


<COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3296" width=103><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3200" width=100><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2176" width=68><TBODY>
</TBODY>
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
can you post some more sample data with desired result ?

i am not getting what actually you need
 
Upvote 0
Basically the only cell I am trying to figure out the formula for is C3

A1 and B1 are Kit Part Numbers.
A2:A10 are parts that make up that kit same for B2:B10

C2 and C4:C10 Code in those cells is if($A2=$B2,"",$B2) so if A2 = B2 then blank else B2 Value
C3 is my tricky one. If B3 = PartD then C3 = PartD, but if B3 does not equal PartD i want if($A3=$B3,"",$B3)

I cant figure out how to put that all together in a formula.

Does that explain it more.
 
Upvote 0
cam you pls post some sample data with header of column and where you want to put formula with desired result ?
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

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