I am trying to perform a vlookup into the CAP file, to bring in price and contracts from Premier file.
As shown in the image, I have attached an example of "Matched rows included in the join result" that has 9 values of a particular key, while the original file only has 3.
I want the join result to be exactly 115, which is the #of rows in the original file.
PS: I have to do vlookups from multiple other files. Open to suggestion if there is another better way to do it.
It's difficult to work with a screenshot only. Looks as if you're performing a RIGHT join, not a Left-Join process. Regardless of join methodology, aside from KEY = Premier Key, you'd probably want to consider whatever else is common between the two sets of data and add those common fields in the join process as additional joins to help bring down the duplication. You'll know your data better than we will, so just a matter of experimentation on your end at this point. IF that doesn't help resolve the issue, then you could always consider an Aggregation Step to condense down the number of values.
Best, Don
(Please, don't forget to click Select as Best or Upvote !)
