RagDyer thanks for your assistance. I decided to do this a different way. I
created a conversion matrix for the different product lines and used this to
tie everything together. With over 5,000 different sku's it wasn't easy but
it is working now. Of course when the new product lines are added I may have
to think of something else to make everything work together.

Again thanks for all your time.

Barron

"RagDyer" wrote:

SO ... your example of PL1 and PL2 is *not* accurate!

Let's start from the beginning.

Can you post exact examples of the 2 lists?

Are they paired up in adjoining columns or not?
OR, are they 2 completely separate entities, with no *physical* connection
with each other.
For example, could PL1 be in A20 to A50,
And PL2 in A60 to A75?

What is the determining factor that creates (accepts) a match of
*unidentical* names.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bchappell" wrote in message
...
OK, here is my problem. I have to build a pricing spreadsheet to price
products that cross product lines. I need to be able to input a
nomenclature
from either line and get the pricing for either line. eg:

Product 1 Product 2
W3030 W3030
WMGD3030 W3030
WDFMGD3030 W3030
WMGD3030MI W3030
B30ST B30HDS
B30DDT B30HDS
BDF30FDS BDF30FDS

Some items are the same in both product lines, but product line 1 has more
options than product line 2. When an item is chosen in product line 1 that
is
not available in product line 2 I need it to downgrade to the appropriate
product.

Can anyone help?