Copy Data from a cell to another spreadsheet if common field match

I have two spreadsheet of data.  Sheet 1 ("Files"), column A (has dups) contains a list of item #'s that have a match in sheet 2("Boxes", column A (no dups).  I need to find the match on sheet 2 column A and copy the value from sheet 2 column b to sheet 1 column b.

I'm looking for a formula to do this.

Please see attached


Who is Participating?
Saurabh Singh TeotiaCommented:
Try this formula in B2 and drag it down...


Open in new window

RavenTimAuthor Commented:
Perfect!  Thanks Saurabh
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.