this would work just fine, but I need
a different method of looking up the low/high price.

The first of the two tables looks like this:

Column A B C D E F
Date | Product ID | Prod Name | Units Sold | Sales Price | Total

When i enter a price in column  E, I need the code  to look up the
ProductID in the same row  (i.e cellChanged.Offset (0, -3)) and with
that ProductID I would need to look up low/high prices  in the second
table that resides indifferent worksheet. that table looks as follows:

Col. A B C D
Product ID | Product Name | Low price | high  price |

Hope this makes more sense. I think I need to use the Find method but
I am not sure how. If you can help?