Dynamic pricing from different price lists

Hello All,

For a line of business we created a price list to dynamically pull the pricing based on the list price on the item with an added surcharge.

Now we have a requirement to pull pricing from a new price list if the item exists in both the price lists. How can I achieve this?

Example:

Item X

Price List 1: Item list Price ($100) + Surcharge (30%) -> $130

Price List 2 (New): $110

In this case, price for Item X has to be $110 on the SO

Thank you!

KC