Change output of text

[wmunsey81]

I know this is probably an easy fix, but I have a vlookup on an excel worksheet that is a form view of some data I have. One of the lookups is a Boolean Y/N and displays 'Y' or 'N'. Unfortunately, I want the data on the worksheet to say 'Yes' when it finds 'Y' and 'N' when it says 'No'.

=IF(ISNA(VLOOKUP(E5,RepairDataBase,36,FALSE)=TRUE),"",VLOOKUP(E5,RepairDataBase,36,FALSE))

Above is my present formula... what would I add to make it say yes or no.

Thank you, my brain is mush today so I could use the extra help.

 

[Joe4]

If you can use a "helper" cell, it is pretty easy, i.e.

=IF(G1="Y","Yes",IF(G1="N","No",""))

Also, note that if you have a version of Excel that has the IFERROR function, you can simplify your original formula to:

=IFERROR([COLOR=#333333]VLOOKUP(E5,RepairDataBase,36,FALSE),"")
[/COLOR]

 

[wmunsey81]

Ahh, thats true on the iferror. How would I incorporate the IF function in the vlookup though?

 

[Joe4]

Just plug the whole function in wherever you see the "Y" and "N", i.e.

=IF(IFERROR([COLOR=#333333][FONT=Verdana]VLOOKUP(E5,RepairDataBase,36,FALSE),"")="Y"[/FONT][/COLOR],"Yes",IF(IFERROR([COLOR=#333333][FONT=Verdana]VLOOKUP(E5,RepairDataBase,36,FALSE),"")[/FONT][/COLOR]="N","No",""))

 

[wmunsey81]

Ahhhh.. I knew it was that simple.. I really should get some sleep. Thank you for the help.

 

[Joe4]

You are welcome.