Your data layout came thru all muddled up.
However, in a VLookUp formula, if the last argument is True then the
data in Column 1 must be in ascending order.
Try 0 as the last argument and see what happens.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Stee n"
wrote in message
Hi
I try to use vlookup to get values from another worksheet, but do not get
the expected values.
-snip-
The problem is that I dont get the value 100 as expected, but insted a value 999!
Any help?