Hi,

I have no idea what Va2 or V3 has got to do with your question.

Try these for looking up where no exact match exists.

To find a lower value

=VLOOKUP(D1,A2:B6,2,TRUE)


To find the higher value

=MIN(IF(A2:A6=D1,B2:B6))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.


Mike


"alawi" wrote:

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