Hi All

I want to enter the following formula

=VLOOKUP(D3,'[172-sep-14.xlsx]Sheet1'!$A$4:$C$34,3,FALSE)

with 172-sep-14 being a file name

is it possible to have all or part of the file name as a variable

Example

enter a number 172 into cell A3 and for that number to be used in the formula

=VLOOKUP(D3,'[A3-sep-14.xlsx]Sheet1'!$A$4:$C$34,3,FALSE) somehow for the 172 to be dragged from cell A3

I hope this makes sense?