Just link the value in the cell returning the dropdown list into the first
part of the VLookup formula.

If that cell is C1

and the formula is in A1 then the initial part of the formula is
=VLookup(C1,......).

Any change in C1 will trigger a change in A1.

Paul


"
wrote in message ...
I have a group of files named sequentially by date. I want to use a
dropdown
list to select which file to pull information from. How can I insert the
filename from the dropdown list into a vlookup formula to get the
information
from the correct file?