I'm trying to use VLOOKUP where if the condition is met, return a value of Y. If it's not met, return a value of N
This produces the Y but produces the #N/A value if the condition is not met. How do I modify my formula so it produces N instead on #N/A?
Thank you in advance
This produces the Y but produces the #N/A value if the condition is not met. How do I modify my formula so it produces N instead on #N/A?
Thank you in advance