Cell contains one or many fo many things

[GonzoB]

Hi Helpers,

I'm using function switch trying to achieve that if the source field is blank then the target field (where the function sits) remains blank too. Using the below function I get #N/A currently when F2 is blank, I would like the cell to be blank instead of #N/A. I was trying to use BLANK() and ISBLANK() as arguments but did not work. Can you advise how to have the field empty?

=SWITCH(F2,"S","S","P","P","VA","VX","P;S;VA","ALL","","")

Thanks

 

[Fluff]

You just need to remove the final argument like

=SWITCH(F2,"S","S","P","P","VA","VX","P;S;VA","ALL","")

 

[GonzoB]

Thank you Fluff.

 

[Fluff]

You're welcome & thanks for the feedback.