need to compare data in one column to another...

[whynot]

Have data in columns a, b, c, and d. Want to compare if data in column a = column c. if it does subtract data in c from d. i have 57 lines of data.
thank you for the help.

 

[Asbestos_Jen]

What do you want it to do if a is not = c?

=IF(A1=C1,C1-D1)

 

[whynot]

i need to compare the data in column A to all the range of data in column d and when there is a match subtract the data in cell b with data in cell e. The data column A and column D are the same but in different order. Sorry should have been more clear.

 

[Cubist]

What you're saying is inconsistent with the original post #1. Can you share the item data set with some expected results using XL2BB?
For example,
1) you said you have column A-D. Now you have A-E.
2) you said check if A=C, now it's A=D

 

[whynot]

Apologize for the confusion. I am having problems with XL2BB. So i am hoping the following picture helps. I would like to compare the data in Column A with the data in Column E. The data is the same but sorted differently. When the data in the cells in column a match column E i would like to subtract the data in Column B from the data in Column F. For example, A3 matches E3 so i would like to subtract 14,460-13,988 and put the answer in column D. hope that makes sense. thank you for your help.

 

[Cubist]

Try this. Adjust your references.

=C3 - XLOOKUP(A3,$E$3:$E$60,$F$3:$F$60,,0)

 

[whynot]

that worked. Thank you very much!!!!

 

[Cubist]

that worked. Thank you very much!!!!

You're welcome. It should've been B3, not C3 above but you probably figured that out.