Lookup, Index, and Trend

K

Ken

Hi,

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

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

link to other workbooks 2
Absolute maximum 2
Excel Formula 16
on mousedown event for a cell? 1
How to convert Dollars & cents from numbers to words? 2
Chart_MouseMove 1
Saving file via Macro without being prompted 2
Four criteria MATCH INDEX lookup of date between matching two text 9

Top