I have a file that is a summary. I want to look up data in another file
using a cell in the summary file to define part of the file name. For
example: Cell A5 contains 2008. I want to have a formula like
=VLOOKUP(B4,'H:\Sarah P\CQI or PIP\Acute Inventory\Test
Process\[2008.xls]count_sheet'!$B:$E,4,FALSE) I want to use the cell
referance of A5 to represent the number (2008) in the formula.
Bookmarks