[Sam]

hi everyone

i am using the vlookup function to get data from another worksheet in
another workbook. this all works fine but my issue is i am constantly
changing the title of the workbookn (different versions) with the data in it.
is there a way to use a wildcard in a file name in the VLOOKUP function?

eg.
VLOOKUP($E3,'[Workbook v2.xls]worksheet'!$A:B$,2,false]

i want to turn it into:
VLOOKUP($E3,'[Workbook v3.xls]worksheet'!$A:B$,2,false]