View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
intricatefool
 
Posts: n/a
Default Lookup multiple workbooks


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 the correct
way?

I am getting an error every time...! Please help!


--
intricatefool
------------------------------------------------------------------------
intricatefool's Profile: http://www.excelforum.com/member.php...o&userid=32919
View this thread: http://www.excelforum.com/showthread...hreadid=547942