You're welcome - glad you found a way to do it.

Pete

On Jun 30, 9:48*pm, blucajun
wrote:
Thanks for the direction and explanation. *I ended up swapping the forumlas
-I put my original forumla from column H into column L and then I copied your
forumla into column H. *So it looks to see what was selected in columns C
(mileage or other) and puts the value into column L. *Column H looks to
column L and if there is a forumula, it pulls it in. *Works great now! *
Thanks so much!