Using indirect formula within Vlookup

Topic

New Reply

I have a workbook where I use a vlookup which looks up a value in another workbook

I want to use an indirect formula so that I can change the year when the file name year changes from say Brtbsept20014 to BR1Tbsept2015

See attached sample files

Your assistance in resolving this is most appreciated

Reply | Quote

Replies

HowardC, try this:

=VLOOKUP(A5,INDIRECT(“[Br1Tbsept” & $C$1 &”.xls]Sheet1!$A$1:$D$100″),4,FALSE)

Reply | Quote

Hi Kweaver

Thanks for the help, much appreciated

Reply | Quote