Hi SamT
thanks. you got the brain thinking.
I added an additional column to the look up values page and turned it into a Vlookup.

Works well. thanks