Originally Posted by
sonar
Hi
I used the formula
=VLOOKUP(VALUE($A$10),Mo!$A:$D,4,FALSE)
because it seems to work and it does the job, I am not even going to ask why it works, or try to explain how it works, its beyond me, I know when I am defeated.
but I have formulated it to
=IF(ISERROR(IF($AH10=(VLOOKUP(VALUE($A10),We!$A:$D,4,FALSE)),"",(VLOOKUP(VALUE($A10),We!$A:$D,4,FALSE)))),"",(IF($AH10=(VLOOKUP(VALUE($A10),We!$A:$D,4,FALSE)),"",(VLOOKUP(VALUE($A10),We!$A:$D,4,FALSE)))))
and that works
but now I want to formulate
=VLOOKUP(VALUE($A$10),Mo!$A:$D,4,FALSE)
in column AH10
not to give me an #N/A error, by
doing the following:
=IF(ISERROR(VLOOKUP(VALUE($A$10),Mo!$A:$D,4,FALSE),"",VLOOKUP(VALUE($A$10),Mo!$A:$D,4,FALSE))
but everytime I do it, it complains about the ,"",.
Any idea what stupid mistake I could have made here? I mean, there must be something wrong with the formula for excel to complain about it.
Bookmarks