Formula to search for a certain cell in another worbook

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


April 27th, 2015 1:11pm

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.

B4:  Sheet1
B5:  A1
B6:  =INDIRECT("[W2.xlsm]"&B4&"!"&B5)

Andreas.

Free Windows Admin Tool Kit Click here and download it now
April 27th, 2015 3:23pm

This formula does the same like all the other I have tried. It just gives me a #REF!

Is there something I'm missing. I already have both files open, is there something else I am supposed to do?

-Juan

April 27th, 2015 4:28pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics