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