I've inquired about this before, but I am still very confused.
I've attached a sample of what I'm working on below.
I have three worksheets. The first two contain the data I want to map together:
1. WWID (6 Columns):
WWID | YEAR | LITER | MAKE | MODEL | SUBMODEL
2. HOUSE (7 Columns):
HOUSE_ID | YEAR | LITER | MAKE | MODEL | SUBMODEL | Part_No
The 3rd sheet Is my Desired Sheet.
These are the columns I want:
WWID | HOUSE_ID | Part_No
So basically I want the Year, Liter, Make, Model, and Submodel columns from the first two worksheets to line up, match, and create the third.
Can anyone show me how to do this?
Bookmarks