Thread: Help with INDIRECT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spreadsheet
 
Posts: n/a
Default Help with INDIRECT

Hi, I solved my own problem, it was just a simple mistake. There was no
need for INDIRECT anyways. I just forgot to include the row of colum
headings in the array reference. Here's the working formula:

A10=HLOOKUP($A$9,INDIRECT("'"&$B$5&"'!A1 :AA1000"),2)
A11=HLOOKUP($A$9,INDIRECT("'"&$B$5&"'!A1 :AA1000"),3)
A12=HLOOKUP($A$9,INDIRECT("'"&$B$5&"'!A1 :AA1000"),4)


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=549565

Reply With QuoteReply With Quote