If cell = value from column then show ..

[royeti]

Hello.
I have two sheets and I want to do the following:
1. to identify the duplicates in column A of the two sheets;
2. in sheet1 column C, I want to be enterd the values from sheet2 column B, if the value in column A is identical (like in screenshot).

Thank you.

[AliGW]

Try this:

=IFERROR(VLOOKUP(Foaie1!A2,Foaie2!$A$2:$B$4,2,0),"No Alias")

[Pete_UK]

Put this formula in C2 of Sheet1:

=IFERROR(VLOOKUP(A2,Foaie2!$A$2:$B$4,2,0),"")

then copy down. You may need to change the commas ( , ) in the formula to semicolons ( ; ), according to your regional settings.

I'm not sure how you want to identify duplicates - using conditional formatting, or another column?

Hope this helps.

Pete

[royeti]

Thank you.
Worked.
You are the best!

[AliGW]

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