Hi, I am trying to match item numbers and unit of measure on one worksheet
to a master price list. My problem is that for each item number there are
several units of measure and I need to be sure and use the right price.

Worksheet 1 Price List

item unit of measure item unit of measure
price


I know how to do this with a sumproduct formula but this makes the workbook
calc. very slowy. So I am trying other ways.

=INDEX('price list'!$D:$D,MATCH($B2,'price list'!$A:$A,0),match(($c2,'price
list'!$b:$b,0)))) is the formula I am trying but am having problems with.


Thank you,


todd