Hi,

I am trying to vlookup to find a written range name and then use that range (once found) to be the table array of another vlookup. Is this possible? I cant get it to work at the moment but am wondering if I need to insert signs around the range that has been looked up e.g[] or ''.

Any ideas anyone? Hope thats clear

TT25