Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup
Help,
I have excel spreadsheets that have been saved per person in my school. Because each year, the teachers may switch grade levels, I do not want my Vlookup to be setup for that teacher, because I do not want to change formulas each year. I have three cells per teacher on my master excel spreadsheet that lists the directory "N:\shared\ teachers", another cell that lists the year "\2005" and another cell that lists the teacher's name "marley". I can use the concatenate function to join the names together (=CONCATENATE(D2,D3,D4)), but cannot get the Vlookup function to view the contents of the concatenate cell as the file name within the Vlookup function..... =VLOOKUP(C6,'N:\shared\teachers\2005\marley[budget fall 2005.xls]PEP 2004-2005'!$C$6:$D$16,2) Does anyone have any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |