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


--
jasmithjr
------------------------------------------------------------------------
jasmithjr's Profile: http://www.excelforum.com/member.php...o&userid=35809
View this thread: http://www.excelforum.com/showthread...hreadid=555816