Vlookup changing cell

[Vadimchik]

Hi everyone,

I'd like to use vlookup with a table array that changes according to the month(the files are sorted according to the month).

The changing month is no problem of course, what I'd like is to use vlookup with a table array that is based partly on a cell, for example:

D8: Vlookup(D2,'G:\Collection Files\[$E$4.xls]Sheet1'!$A$3:$Q$220,7,0)
D9: Vlookup(D2,'G:\Collection Files\[$E$4.xls]Sheet1'!$A$3:$Q$220,11,0)
D10: Vlookup(D2,'G:\Collection Files\[$E$4.xls]Sheet1'!$A$3:$Q$220,13,0)
D11: Vlookup(D2,'G:\Collection Files\[$E$4.xls]Sheet1'!$A$3:$Q$220,16,0)



I have provided an example - results should be in cells D8:D11,

Not sure where to start, would love any help on this matter.


Thank you