Previous Topic Next Topic

Compare two sheets and copy cell if match found.

Closed
CJoubert
Posts
1
Registration date
Thursday January 22, 2015
Status
Member
Last seen
January 22, 2015
 - Jan 22, 2015 at 10:46 AM
Hi guys.

I have two sheets and would like to compare sheet2 with data in sheet1 and copy a cell data from sheet1 to sheet2.

Eg:
SHEET1
A B C
shelve no barcode library
1 320065 main
5 6700057466 main
2 745789 remote


SHEET2
A B B D E F
Call no Author Title ISBN Barcode
EKF HEL Emma The Nuts 9781415005590 6700057466
EKF HAL John Space 9781415005590 6700057466
EKF BEL Peter Sam 9781415005590 6700057466


I want to take SHEET2 E2 (barcode) and see if the barcode is in SHEET1 column B. If it is, the shelve no (in SHEET1 column A) must be copied to SHEET2 column F next to the record.

Thank you.