Thank you for your patience. So what you actually need is that, in your original vlookup results, (see column L, the one I added for immediate comparison of results) is the result is 0, Z must be displayed. If the result is a blank, then keep it as blank.
After few tries I have perfected it. The formulas will be:
(See actual formula in the sheet attached)
The cure here is a nested IF. If the vlookup result is 0, it will display Z, if not, then another IF takes place. If the vlookup formula results to BLANK, then display it as blank. Otherwise, display the vlookup formula results.
Here is the completed file:http://wikisend.com/download/255846/Sample-File_rev4.xlsx
Please remember to rate my service positively (3-5 stars/faces)
once you have all the information you need. Tips
are always highly appreciated!
If you have any other questions, please ask me or reply to me
– I’ll be happy to respond.