Hi!
I would be glad to get help on this isse-googeling has so far not solved it for me.
I have two Excelsheets-which both contain multiple columns. The leftmost column (A-column) in both sheets contains "ID", and this is the basis for the operation I want to carry out.
I want to insert data in column B (sheet 1) based on column B (sheet 2). What rows to pick data from should depend upon the matching of the ID between column A in sheet 1 and 2.
In other words- if the ID is 100002 I need to return corresponding values for that ID into the other sheet. All IDs exist in both sheets-but sheet 1 contain duplicates.
Help is greatly appreciated!
Regards,
Maria
Bookmarks