Multi Part IF statement

[mossman65]

Good Morning.

I have been looking through the forums to find a solution. I'm going to keep looking but I thought i would post to see if some one could point me in the right direction. I'm a novice at Excel so please pardon my ignorance.

I would like to run a IF statement that will first compare the part numbers in column A and C. IF the part number in column A does not appear in column C delete the entire row. DONE

Second i would like to compare and update based on the part numbers and inventory count.

IF Column B count differs from column D count, update column D with the count from column B

The data:
A B C D
1-25182-C 1 1-23182-X 0
1-25182-D 1 1-23202-X 0
1-25182-DO 1 1-23242-X 0
1-25182-F 79 1-25182-X 0
1-25182-G 0 1-25201-X 0


Thank you very much!
Aaron

 

[texasalynn]

you can't delete a row with a formula. That will require a macro solution

 

[mossman65]

you can't delete a row with a formula. That will require a macro solution

Thank you for your reply. I have manually taken care of the deletion.

I now have to workbooks that i need to compare and update the inventory quantity based on the part number. Is there a simple formula or macro that will help me accomplish this?

Thank you!
Aaron

 

[texasalynn]

a vlookup should work for that

 

[mossman65]

a vlookup should work for that

Thank you, this has been solved