Glad to hear your success!

keep on exceling....

--
steveB

Remove "AYN" from email to respond
"MBlake" wrote in message
...
Hi Steve,
Thanks for the response. I had a lot of help from this group when kicking
off my userform and VLOOKUP and this was the easiest method for me to
learn at the time. I am now adding more knowledge and will take on board
your suggestion of ListIndex along with a few others.

In the meantime I have solved my problem, it took some time but eventually
the light went on!. Having changed the lists from "RPU (2 spaces) 1" to
"RPU (1 space) 1", I forgot to make the same change to the lookup table!
DOH!

Thanks again,
Mickey