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