Hi!
The basic formula would be something like this:
=INDEX(SALES,MATCH(1,(RANGE=LOCATION)*(RANGE=CUSTO MER)*
(RANGE=PRODUCT),0))
Need more detail for a more specific answer.
Biff
-----Original Message-----
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.
.
|