Compare two columns and return a value

[kjxavier]

I use Windows 7 Pro Service Pack 1
MS Office 2013

I have 4 columns in a sheet A,B,C,D
I wish to check each Cell values in Column A and compare it with Column C
When Cell Value in Column A matches value in Column C,
Column C's corresponding value in column D should be copied to column B (adjacent to value in Column A)

Result should look like:
Please have a look at the Sheet1 in the attachment (I have copied values from Column D manually to 'B')

Formula is required for:Column B

B= Column's C's corresponding D value (where values in column A and C matches)

[rondeondon]

in b2 put
=if(a2=c2,d2,"")
copy the formula through colum b

[samba_ravi]

You have duplicate values in C7 & C13, in this case which value to display in B12

[sandy666]

btw. update your profile about excel version

version.jpg

anyway maybe try: =IFNA(INDEX($D$1:$D$13,MATCH(A1,$C$1:$C$13,0)),"")
or PowerQuery with, imho, better result (result table can be placed anywhere)

[kjxavier]

Perfect formula!

Thanks a lot

[sandy666]

You are welcome
Have a nice day

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.