=SUMPRODUCT(--(customer_ID=Sheet2!C2),--(Item_ID=Sheet2!J2),Bill_rate)


"klafert" wrote:

I have 2 spreadsheets. Source spreadsheet has 3 column a = customer ID,
Column B = Item ID, Column C = Bill rate.

2nd spreadsheet has Columns a-u. Column C=Customer Id, Column J = Item ID,
which will match column A & B in the source spreadsheet. Then I have column P
= Billing rate. For this field I need to pull the billing rate from the
source spreadsheet. So in other words if column C & J in 2nd spreadsheet
matches column A & B in source spreadsheet then I it to return the value from
Column C in the source sheet into the 2nd spreadsheet in column P. They must
match exactly to return the customer billing rate. I used this formula but
it is not working:

=VLOOKUP(C2&"/"&J2,'[customer billing rates.xls]Sheet1'!$A$1:$C$62182,3). I
used VLookup before but only with one lookup value. I have played around
with Match and Index. Thanks for any help and I hope that I am very clear in
my explanation.

Example:

Source Spreadsheet:

Columns

A2 B2 C2
Cust. ID Item ID Billing rate
Joe Blow 2XR 50.00
Mandy Moore 2XR 40.00
Sandy Shore 2XR 30.00

Lookup Spreadsheet:


C2 J2 P2
Cust Id Item ID Billing Rate
Joe Blow 2XR ?????
Mandy Moore 2XR ??????
Sandy Shore 2XR ?????

Also, I get an error = not able to save due to resources - choose less data
or ...