Ok, I am having a problem with the vlookup. In the first column I am trying to looking a the numbers like 18 78 would give me the results from the 18 90 line below, that is what I want. But my problem is trying to get the results to match the 18 100 line results. It will give me the result as #N/A.

This is the formula I am using. Could anyone help me in resolving this problem.

=VLOOKUP(H4,DT202:DV206,2)


18 50 1 3 135
18 75 2 3 160
18 90 2 4 185
18 99 2 5 235
18 100 3 6 335


Thanking any help in advance.

Thanks, John