Comparing Data

Closed
Linda - May 25, 2011 at 02:27 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 25, 2011 at 02:48 PM
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 responses

This is in Excel by the way.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 25, 2011 at 02:48 PM
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
0