View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alawi Alawi is offline
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