VBA to paste data if two cells are the same

[Excel43]

Hi,

I have two sheets. In sheet B I got Name and Group at H2-I6 (blue image). In Sheet A I got Name and Group at A1-B5. What I would like to do is pasting the groups from sheet A to sheet B if the names are the same.

For example. If Eric is found in the H column, the cell next to Eric (column I) should say "A".

Note that the length of the list could be much longer (maybe 50-100 names) and not in order.

I would really appreciate if someone also could explain what the code does, as I am trying to learn.

 

[Fluff]

Hi & welcome to MrExcel.
How about, in I3 copied down
=IFERROR(VLOOKUP(H3,Sheet1!$A$2:$B$200,2,0),"")

change sheet name to suit

 

[Excel43]

Actually, this works great! Wow what a fast answear. Thank you

 

[Fluff]

You're welcome & thanks for the feedback