compare data in different workbooks

  • Thread starter Thread starter Jerry H
  • Start date Start date
J

Jerry H

I have a workbook that contains following columns (plus
others): Customer ID, Part number, contact number.
Any customer can request any part. For every combination
of customer and part number there is a unique contract
number. When I enter a customer ID and part number in my
second workbook i want the contract number that
represents this combination from first workbook to
automatically populate.

Thanks
 
=INDEX([Book2]Data!$C$1:$C$200,MATCH(A1&B1,[Book2]Data!$A1:$A200&[Book2]Data
!$B1:$B200,0),1)

entered with Ctrl+shift+Enter rather than just enter (since it is an array
formula).

Change [Book2] to your workbook name and include the .xls. I was testing
on a new workbook so it doesn't have an xls. extension.

I assume the workbook with the contract number is open.

In the second workbook, the Customer ID was entered in A1 and Part Number in
B1
 
Back
Top