Pl stay in the same thread, keep discussions there
You say:
I have use =ISERROR((VLOOKUP.............)),
but hey, that's not what I suggested.
My suggestion was:
Try trapping it with ISERROR, like this:
=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))
If you frame it up as per the above expression,
you should get the desired results. Try it again
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---