Are you using all 4 arguments of the function?

Is the 4th argument 0 or "False", denoting that an exact match is called
for?

If "yes" to the above, post the formula you're using.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"seeinred04" wrote in message
...
i have a data base on sheet 1, formula is on sheet 2. its sorted ascending
everything looks right, but it returns the value from the correct column
but
always picks from the previous row.