Thank you for your.

This works perfectly apart from one thing, I am trying to use this formula for 3 different column look ups on the same worksheet. Once I have entered the formula in the 3 coloumns, when changing the vlookup data in one column it changes all 3.

Thoughts?

Matt