Vlookup - Having a cell have an automatic dash

[mgro123]

Hopefully I can word this correctly - I am looking to have a cell where the resting cell info is a "-" dash, then when you enter the appropriate value for the vlookup it changes to yes or no. This is the vlookup formula that I am working with - how would I add a secondary part to show this?

=IF(ISERROR(VLOOKUP(N31,Opth!$A$2:$C$296,1,0)), "no", "yes")

 

[Jeffrey Mahoney]

You have office 365, let me see if I understand correctly.

=LET(V,IFERROR(VLOOKUP(N31,Opth!$A$2:$C$296,1,0),"No"),IFS(V=0,"-",V="No","No",TRUE,"yes"))