mdmack,

but how can I use that for a whole column? Also do you know if it will run quicker than a vlookup? if you don't know if it is quicker just help me run it on a whole column and I will test it.