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

BMR2022.docx

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

=vlookup(a2,sheet2!A:B,2,0)

Open in new window


Saurabh...
0
 
RavenTimAuthor Commented:
Perfect!  Thanks Saurabh
0
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.