Re: How to put formatted text in one cell when another cell value is blank

Question is not clear enough. You may try IF() or MATCH() function. You may also need combination of few other functions. Post few sample data and show your expected output.