Posted by Bill Witowski on August 16, 2001 8:34 AM
How do I create a V-Lookup that will go to a table in another excel workbook and search on multiple variables. For example, I would like to search my vendors for the following types of variables.
Manufacturer Name in the first column
Product in the second column,
Model Number in the third column,
In my primary document (the one I want to pull information into) I have a list of Manufacturers with their Products and Models in first three columns. In the other document I have a table with the same three columns plus a fourth column that has a percentage number. I would like to be able to make my V-Lookup go to the table and pull in the data from the fourth column whenever I have an exact match with the first three columns in my primary document.