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 5 hours 47 minutes ago