Lorry wrote...
I am using the vlookup function and need it to return the match for the next
highest value, not the closest below the value. Example: *Value is 61 and I
need it to return the information in column two below (.87) but it's
returning .8, because 59 is below 61. I need it to move to the next up, 64..
Can someone help?

54 *.59
59 *.8
64 *.87

If your table were in C3:D5 and sorted in ascending order on the 1st
column and your lookup value in cell C7, you could try

=INDEX(D3:D5,MATCH(C7,C3:C5)+(VLOOKUP(C7,C3:D5,1)< C7))