Vlookup Problem

[erezlevi25]

Hi there,
I am trying to use vlookup function that takes the table array as an argument from another cell, means that i want to use =VLOOKUP(F109+1,H109,8,0) instaed of this =VLOOKUP(F109+1,[NWL.xlsx]test!A1:I81,8,0) where H109 contains the table array value. SO far I get the #N/A error.

Thanks so much, Erez.

[Pete_UK]

Try it like this:

=VLOOKUP(F109+1,INDIRECT(H109),8,0)

Note that the other file will have to be open in the same instance of Excel, as INDIRECT does not work with closed files.

Hope this helps.

Pete

[erezlevi25]

that works! thank you so much!

[Pete_UK]

Glad to hear that, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete