Hi xor

Thanks for the reply i tried the formula but it just brings back true if it matches upper or lower case but im wanting it to bring back whatever is in the second column on sheet 4.

Hope this explains it a little better as I dont think I explained it to well in my original post.

Thanks again for the assistance on this