I have two tables that both contain entries representing the same item. The tables have similar fields, such as 'Date', 'Product', etc. but table A has the Description field that i need , while Table B has an 'ID' field representing each entry. Is there a way to get excel to match entries between the two tables based on multiple fields that exist in both tables, and return the 'ID' field from table B to the correct entry in Table B?
Bookmarks