Hi HP RodNuclear,

Strange problem. I think you can't have the name of a range the same as the worksheet. Either that or you have an invalid character in the named range or worksheet name.

I changed the Name Range to ElementTable and did a VLookup and it worked fine.

See if you have a naming problem.