I am making a lookup where the data is stored on one sheet and on the main sheet the name is entered and all of the information is entered. this works fine if you just use a - h but when I use the proper names such as Natural Brick or clay slabs it either works fine, comes up with a N/A error or enterd data of a different row.

I don't have a clue what is going on and if you want the table to make more sense then I can send it to you in a new thread.

Thanks

RICOUK