I am trying to find a IF function with multiple criteria to get the output as "" (Blank).
I want If function to return "", if its vlookup value is "" or #N/A.
Below is the function i am using, but it still throws #N/A for few cells, while it must return ""
Please find the attachment.
Please correct my small mistake.