Nesting If and Vlookup

[jamesstorx]

Hi There,

I think that I have to nest If and Vlookup, but I am not sure.

If cell C2 is between the values in E9 and F9 then C4 = D9


I have attached an example as well.

[Huron]

Try

=INDEX(D9:D14,MATCH(C2,E9:E14,1))

I assume the value in F13 in your table should be 533.4 not 433.4

[jamesstorx]

Try

=INDEX(D9:D14,MATCH(C2,E9:E14,1))

I assume the value in F13 in your table should be 533.4 not 433.4

That works great, Thanks