Comparing Data

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I would like to look at two columns A and C and then if they match take the quantity in column D and insert it in Column B.
So
Column A Column B Column C Column D
Item # Quantity Item # Quantity
123456 123456 6
125678 245678 7
245678 345699 2

2 replies

This is in Excel by the way.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can use an IF statement in cell B

=IF(A1=C1, D1,"")

basically saying if A1 is same as C1, then show me the value in D1, else show me blank