Lookup, Index, and Trend

Hi,

I don't use forums, etc... very often.

Thanks,
Ken

++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++
I'm trying to utilize this Excel formula to search "named" cells:

=IF(B1=LOOKUP(B1,x,x), LOOKUP(INDEX(x,MATCH(LOOKUP(B1,x,x),x,0)x,y),TREND (y,x,B1))


The object:
to return intermediate values uses (linear) extrapolation.


The Problem:
it doesn't work.


Any suggestions greatly appreciated.


************************************************** *********


Formula is from "MS Excel 2000 Formulas" by J. Walkenbach (p. 230)

Please see attached Excel File.


Thanks!
-Ken

See the posting in the ASP Lounge

S-