Hello,
In working in Excel 2010.
I have this VLOOKUP function: =VLOOKUP(A2,'C:\Users\Kim Udell\...\[Quality-Review-XXX..X-System-Test-Plan.xlsx]Peer Review Summary Form'!$C$14:$F$22,4,False)
where the XXX..X represents a specific file name, which is different for each file. The rest of the file name is the same across all files concerned.
What I would like to do is put this information (the different part of the file name) into a cell on the same worksheet as the formula, and automatically populate this portion of the formula when the data is put into the separate cell.
HELP PLEASE ?!?!
Bookmarks