Excel: Can't select table array for VLOOKUP. Help! 1

[Gymnast14]

My co-worker is trying to do a VLookup between two spreadsheets. When she does step 2 of the formula, table array, she clicks over to the other worksheet to try to select the range of cells. However - nothing happens! She doesn't get the blinking "Selected" indicator.

I emailed myself the same two spreadsheets, and I'm able to do this with no issues. So it has to be some setting on her Excel. Any ideas?

If this doesn't make sense, I will try to upload a screenshot of what I'm trying to explain. Thanks in advance!

 

[kristal9]

Sounds to me like your co worker has two instances of Excel open while you have two Excel files open in one instance.

 

[Gymnast14]

Hmm, interesting. I do know for a fact that she did have two instances open. I will go over to her computer later today and try your suggestion! I'll let you know what happens. Thanks!

 

[Gymnast14]

Kristal - You are a genius. This is exactly what was causing the issue. I had search all over and couldn't find anything. Thank you SO much for answering! We are happy campers here.