Hi, I did this exercise years ago and for some reason cannot remember how I did it.

I have a list of about 10000 parts. Each part has a letter assigned to it in column B. Column C has a price. I need to calculate a new price by using a multiplier stored in another table. The multiplier to use is determined by the letter in column B.

This is a very basic example of what I'm dealing with. I'm looking at 10000 parts and about 50 different multipliers. Codes are generally three characters.

[TABLE="width: 384"]

Part

Code

Price

[TD="colspan: 2"]Multiplier

[/TD]

[TD="align: right"]12345

[/TD]

A

[TD="align: right"]2.00

[/TD]

A

[TD="align: right"]0.1

[/TD]

[TD="align: right"]12346

[/TD]

B

[TD="align: right"]2.00

[/TD]

B

[TD="align: right"]0.2

[/TD]

[TD="align: right"]12347

[/TD]

C

[TD="align: right"]2.00

[/TD]

C

[TD="align: right"]0.3

[/TD]

[TD="align: right"]12348

[/TD]

B

[TD="align: right"]2.00

[/TD]

D

[TD="align: right"]0.4

[/TD]

[TD="align: right"]12349

[/TD]

B

[TD="align: right"]2.00

[/TD]

G

[TD="align: right"]0.5

[/TD]

[TD="align: right"]12350

[/TD]

A

[TD="align: right"]2.00

[/TD]

Z

[TD="align: right"]0.6

[/TD]

[TD="align: right"]12351

[/TD]

D

[TD="align: right"]2.00

[/TD]

[TD="align: right"]12352

[/TD]

Z

[TD="align: right"]2.00

[/TD]

[TD="align: right"]12353

[/TD]

G

[TD="align: right"]2.00

[/TD]

[TD="align: right"]Thank you!

[/TD]

[TD="align: right"][/TD]

[/TABLE]