We help IT Professionals succeed at work.

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

RavenTim
RavenTim asked
on
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.
Comment
Watch Question

Top Expert 2015
Commented:
Try this formula in B2 and drag it down...

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

Open in new window


Saurabh...

Author

Commented:
Perfect!  Thanks Saurabh