find files from a dropdown list

  • Thread starter Thread starter pmyers123
  • Start date Start date
P

pmyers123

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?
 
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
 
Back
Top