Thread: Expert VLOOKUP
View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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.
.