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
Hello and welcome to the forum,
What you can do is adding a column to your worksheet 1, for example column E on your sample file, name it "Full Description" and paste this formula
on E2 and drag it down. It will lookup the item code and return the description found on worksheet 2.
=VLOOKUP($C2,Sheet2!$A$2:$B$15,2,FALSE)
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
Works perfectly
Thank you for your help and thank you for the welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks