IFERROR not Working

[menor59]

Hello Folks,

The Following Code is not working

=IFERROR(IF(E6<>"",(INDEX(Prowatch!AI:AI,MATCH(E6,Prowatch!H:H,0))),""),"No Number Listed")

So in E6 theres and email address
On Prowatch Tab AI:AI is a range of email addresses
IF E6 email matches anywhere in Range Match E6 Prowatch H:H which is a phone number
If E6 is blank it returns Blank
If E6 has an Email address, and is found in AI:AI, but H:H match does not have a phone Number show No Number listed

What am i doing wrong?

 

[Marcelo Branco]

Maybe this...

=IFERROR(IF(E6<>"",IF(INDEX(Prowatch!AI:AI,MATCH(E6,Prowatch!H:H,0))=0,"No Number Listed",INDEX(Prowatch!AI:AI,MATCH(E6,Prowatch!H:H,0))),""),"Email not founded")

M.

 

[Scott Huish]

If the phone numbers are entered as actual numbers, and if No Number Listed is acceptable when E6 is not blank and a match isn't found:

=IF(E6="","",SUMIF(Prowatch!AI:AI,E6,Prowatch!H:H))

Format cell as:
[=0]"No Number Listed";(###) ###-####

 

[menor59]

Found the problem...Im a nuckle head...I have the Ranges Backwards..Ugh sorry..

=IFERROR(IF(E6<>"",(INDEX(Prowatch!H:H,MATCH(E6,Prowatch!AI:AI,0))),""),"No Number Listed")