LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Incoherent
 
Posts: n/a
Default Using INDIRECT in INDEX(LINEST.. ) function

=INDEX(LINEST(F17:N17,F16:N16^{1;2;3}),1)

The above formula is part of a much longer formula.

I want to repace the references with the INDIRECT function but I am getting
#REF when I put INDIRECT in as the second argument.

=INDEX(LINEST(INDIRECT(S14),$F$16:$N$16^{1;2;3}),1 ) works fine.

=INDEX(LINEST(INDIRECT(S14),INDIRECT($S$15)^{1;2;3 }),1) when
S15="$F$16:$N$16"
and
=INDEX(LINEST(INDIRECT(S14),INDIRECT($S$15)),1) when S15="$F$16:$N$16^{1;2;3}"
both give #REF

How can I make this work? The Reference size changes depending on input data
set size so I figure I must use INDIRECT. It obviously does not like the
^{1;2;3} array formula part.

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
include INDIRECT function into SUMPRODUCT formula markx Excel Worksheet Functions 1 November 9th 05 05:04 PM
INDIRECT Function - what am I doing wrong? MACRE0 Excel Discussion (Misc queries) 2 October 5th 05 08:47 PM
Indirect or Vlookup Function Justin Excel Worksheet Functions 1 July 29th 05 10:38 PM
INDIRECT function question Joe Excel Worksheet Functions 1 February 14th 05 03:54 PM
Indirect( ) function loosing values when spreadsheets are closed Word4Dummies Excel Worksheet Functions 2 February 13th 05 12:41 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"