Attached is an excerpt of a larger file. On Sheet 1 there are about 30 locations, each with about 200 item codes. Each item code represents a different bank which has an abbreviated description. On Sheet 2 about 14,000 possible banks and their full description.

My objective is to merge the two sheets so that the columns going across are:
Location, Funds, Item Code, Abbreviated Description, Full Description


Thank you

Book1.xlsx