Hello everyone 

I've been trying to figure out this for a week now and have come nowhere.

I have to workbooks, lets just call them W1 and W2. I need a formula in W1 that looks for a certain sheet in W2 based on the data in cell B4 in W1. Once the sheet has been found, it has to look for a named range in said sheet in cell B5 wich is in W1.

I haven't found anything yet for this and I am not sure if this is even possible, but if someone could help me with this, I would really appreciate it.   

Thank you. -John

• Moved by Lanlan HuangMicrosoft contingent staff Tuesday, April 28, 2015 1:39 AM

Hi John,

Do you mind sharing us some screenshots? It will help us to assist you better.

Regards,

George Zhao
TechNet Community Support