LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default vlookup & Extrapolation

I have the following columns

Va2 177
V3 216.37
V3/rootT3 11.984
Q3 ?


V3/rootT3=11.984 which is not in the table
I need to retrieve the Q3 from a long table looks as following


V / Root.T Q
11.888 0.03450
11.924 0.03456
11.960 0.03463
11.996 0.03469
12.032 0.03475



As you can see 11.984 dose not exists
I need to extrapolate between any tow columns in V / Root.T and return the
answer Q to Q3 cell


How can I do that? Please

 
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
Extrapolation and Interpolation questions wenlianglo Charts and Charting in Excel 0 March 4th 09 01:56 PM
Extrapolation of non linear data andy duncan Excel Worksheet Functions 8 August 8th 07 02:46 PM
extrapolation curves on excel chemistry Charts and Charting in Excel 1 August 3rd 06 04:43 PM
Correcting an extrapolation macro smurray444 Excel Discussion (Misc queries) 2 February 1st 06 10:29 AM
Automating Extrapolation smurray444 Excel Discussion (Misc queries) 1 January 29th 06 01:09 PM


All times are GMT +1. The time now is 04:56 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"