IF and OR Formula

[weaselmcguff]

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

KIT1	KIT2	Need
PartA	PartA
PartB	PartB	PartB
PartC	PartD	PartD

<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>

 

[kevatarvind]

can you post some more sample data with desired result ?

i am not getting what actually you need

 

[weaselmcguff]

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.

 

[kevatarvind]

cam you pls post some sample data with header of column and where you want to put formula with desired result ?

 

[ArthriticPanda]

Hi weasel,

Maybe something like this...

Excel Workbook
	A	B	C
1	KitA	KitB	Need
2	Part A	Part A
3	Part B	Part B	Part B
4	Part C	Part D	Part D
5	Part C	Part E	Part E
6	Part C	Part B	Part B
Sheet1

AP

 

[weaselmcguff]

Thanks worked perfect