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,FALS E)))),"",(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.


--
sonar
------------------------------------------------------------------------
sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=401265