http://groups.google.co.uk/groups?as...=2005&safe=off

That should all be one line in your browser navigation window.

--
Regards,
Tom Ogilvy



"Metalmaniac" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I am trying to create a formula that will lookup values in a column and
find
> those values in another column and then place the value in the row next to
it
> in a specific cell. So far this works with the formula
> (=VLOOKUP(I6,$D$11:$E$223,2)). Now most of the time the value for cell I6
> (thru I n) will not be found in the list ($D$11:$E$223) so I want to
revise
> the formula to do one of two things:
>
> 1. Always "interpolate" between points even when an exact match is found
in
> ($D$11:$E$223)
>
> 2. When the value for cell I6 (thru I n) is not found then find the values
> less than and greater than I6 and interpolate between the two points a
value
> based on the slope of the function defined by the two sets of
corresponding
> data.
>
>
> this is driving me insane!!!! Please help me! I have 20 years of data to
> enter and if I do it manually it will take 20 years.