| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find files from a dropdown list
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find files from a dropdown list
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find files from a dropdown list | Excel Worksheet Functions | |||
| I can not find the list command from the data dropdown menu? | Excel Worksheet Functions | |||
| Using dropdown list to find file | Excel Discussion (Misc queries) | |||
| dropdown list...no help in the help files | New Users to Excel | |||
| userform to display dropdown list of open XL files | Excel Programming | |||
Linear Mode
