Hello, first post. I'm not even sure this is possible but I think I've come to the right place.
In Column C I have a simple IF statement as follows:
=IF(A56=B56,"YES","NO")
Column A
=TRIM(XLOOKUP(A56,fromAconex210420!A:A,fromAconex210420!B:B,"",0))
Column B
=TRIM(XLOOKUP(A56,ReleasedInternal!Q:Q,ReleasedInternal!B:B,"",0))
When both XLOOKUP cells return nothing my IF statement returns YES - both cells are empty so technically they match
How do I get the "empty" cells to return N/A or something other than YES, NO
Thanks in advance!
Jason Poulin
Bookmarks