I need to lookup cells in multiple workbooks. Each workbook has a state
abreviation at the end of the file name.
I am trying to use:
=HLOOKUP($A29,INDIRECT("C:\Data\Data
Collection\Reimburse_Policy_Report_"&A29&".xls]Pharmacy'!$C$6:$D$23"),C$1,FALSE)
A29 in the formula is the state abbreviation to be looked up in each file.
Anyone have any suggestions on how to go about doing this differently or
just a right way of doing this?
I am getting an error every time...! Please help!
Bookmarks