I am trying to use the vlookup function to compare multiple columns in a data
array versus just the 1st column and return one data if all is true.
Example: I have two reports for two different time periods. There is data
in common between the two reports, such as location, customer, and product.
I want to pull the associated data, lets say sales, from one spreadsheet to
the current spreadsheet, only if the location, customer, and product are
identical between the two spreadsheets. How do I do this?? I have tried
using the and worksheet function to no avail.