I need to change a formula. Basically I have 2 excel sheets. In the first I have a column in which is used Vlookup formula. And it is used to find out the assessment text ("Yes", "No"or "Blank" in a table which is in another excel sheet!) What i need to do is to change the vlookup formula in the first sheet in order to have "-" instead of blank cells. How can I do it?
Thank you in advance!