Re: Need similar formulas to do the job


You are missing a ")" for your ISERROR()


sonar Wrote:
> 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.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7094
View this thread: http://www.excelforum.com/showthread.php?threadid=401265

.

Relevant Pages

  • Re: Delphi 2005 Architect Trial
    ... >>I'm going to install it on a virtual PC. ... I don't want it to mess up the ... and it complains that xmlrtl90.bpl is missing.. ...
    (borland.public.delphi.non-technical)
  • Re: Building things with setup.py
    ... In an executable program, all symbols need to ... that's why it it complains about so many missing ... the g77 linker line; try invoking ...
    (comp.lang.python)
  • Re: alphalph package problem
    ... Turgut Durduran wrote: ... I copied the example from alphalph manual but it complains about a ... "missing number" being treated as zero. ...
    (comp.text.tex)
  • Re: How to load display driver under CE6 without K flag?
    ... Display driver in MODULES section -> CE complains about missing K flag ...
    (microsoft.public.windowsce.platbuilder)
  • Re: sigset_t and gcc
    ... > It compiles ok with 'gcc file.c', ... > It complains that 'sigset_t' is undeclared. ... > What options am I missing? ... > int main ...
    (comp.lang.c)