View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default #VALUE! (ANY HELP)

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
---