srezzonico
New member
- Joined
- Sep 29, 2014
- Messages
- 6
- Reaction score
- 0
- Points
- 0
Hi there,
i'm kinda of struggling here...
I have a cell with a tab name/cell (string).
I'm trying to access some data in another the file via a vlookup
something like this, where the tab name is dynamic:
=vlookup(xxx, [filename]tabname!A1, 1)
but can't figure how to use indirect() function.
any suggestion?
i'm kinda of struggling here...
I have a cell with a tab name/cell (string).
I'm trying to access some data in another the file via a vlookup
something like this, where the tab name is dynamic:
=vlookup(xxx, [filename]tabname!A1, 1)
but can't figure how to use indirect() function.
any suggestion?