Comparing Data Closed

Question

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

Linda · Answer

This is in Excel by the way.

rizvisa1 · Answer

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

Comparing Data

2 responses

Similar discussions

Subscribe To Our Newsletter!