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