Not possible using vlookup, in an unsorted list you can use

=INDEX(B1:B10,MATCH(SMALL(A1:A10,COUNTIF(A1:A10,"< "&200)+1),A1:A10,0))

will lookup a value that is greater or equal to 200 in A and return the
value from B
so if it would work in a vlookup it might have looked like

=VLOOKUP(200,A1:B10,2 and so on

--
Regards,

Peo Sjoblom

Portland, Oregon




"atatari" wrote in message
...
Dear Friends,

How can I use Vlookup to give me the closest value greather than or equal
to
vlookup value.For example if my lookup value is 5 and I have 4.9 and
5.1,5.2
It chooses 5.1 and give me the corresponding value.

Thank you,