vlookup table array question

[sunrise06]

When using vlookup that references a table array in a different file saved in a shared drive folder, does that file have to be open for the vlookup to work?

 

[sunrise06]

The Excel table range increases with each additional item added to the table.


Using absolute reference in my other test goes out to over 100 lines.

 

[Aladin Akyurek]

The Excel table range increases with each additional item added to the table.


Using absolute reference in my other test goes out to over 100 lines.

What is the current range?

 

[sunrise06]

For the file setup as a table the current range is - =$A$1:$G$92

 

[Aladin Akyurek]

For the file setup as a table the current range is - =$A$1:$G$92

Try invoking...

=VLOOKUP(A1,'NTK Activity Master.xlsx'!A:G,1,0)

 

[sunrise06]

Awesome, that seems to work.

Thanks!

 

[Aladin Akyurek]

Awesome, that seems to work.

Thanks!

You are welcome.

 

[sunrise06]

Now that I am at the office, and implemented your suggestions, it is not working. I am wondering if it is because the files are on different servers?

It will find a match if it was already in the file but if I add a new item it does not find it and I get an #N/A. I have even tried saving and closing everything and then opening the working file, no luck, I then open the source file as well and it is still not populating. I know I have the right spelling as I copied and pasted into the source file. So frustrating.

Thoughts?

Thanks, again.

 

[Aladin Akyurek]

Now that I am at the office, and implemented your suggestions, it is not working. I am wondering if it is because the files are on different servers?

Is the path perhaps uncertain?

It will find a match if it was already in the file but if I add a new item it does not find it and I get an #N/A. I have even tried saving and closing everything and then opening the working file, no luck, I then open the source file as well and it is still not populating. I know I have the right spelling as I copied and pasted into the source file. So frustrating.

Thoughts?

Thanks, again.

I just opened the closed book, added a new record, saved, and closed the book. I then opened the workbook with the VLOOKUP formula and tested whether the new record picked out. The result is positive: The new record is found.