Hi
I have a sheet I'm building where I need it to look up into another worksheet which has numerous tabs with different names
=VLOOKUP(R10239,(indirect("'S:\Team\10\Team 10\Order Summary\2017\[Order Summary 2017.xlsx]"&AC10239&"'!$C:$L",10),0
But it tells me I'm missing something
AC10239 is the name of the tab in the other workbook
What am I missing?
Hi,
Even if we amend it such that it is syntactically correct, I take it you're aware that INDIRECT does not work on closed workbooks?
Regards
I was yes, so I will open the workbook I need to lookup into, but its easier having this formula than manually changing or recording what I want when needed
Usually when I use indirect, it seems ok but I'm doing a SUMSIF I haven't used vlookup in the indirect formula before
AC10239 is the name of the tab in the other workbook or AC10239 contains the name of the tab in the other workbook? if it contains the name, what is the name?
it contains the name, the name is P1.W1, throughout column AC it will say P1.W1, P1.W2, P3.W1, P6.W4 etc etc
You appear to have parentheses in the wrong places.
Perhaps:
=VLOOKUP(R10239,INDIRECT("'S:\Team\10\Team 10\Order Summary\2017\[Order Summary 2017.xlsx]"&AC10239&"'!$C:$L"),10,0)
Regards
Great i've got thank you
You're welcome!
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks