#1   Report Post  
Using a string within a Vlookup function
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Function with VLOOKUP CoRrRan Excel Worksheet Functions 15 April 8th 05 05:54 PM
make a vlookup using a variable path Alex St-Pierre Excel Worksheet Functions 1 March 3rd 05 12:54 AM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 01:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 11:43 AM
VLOOKUP not working Scott Excel Worksheet Functions 3 November 12th 04 09:06 PM


All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"