▲ 8 r/excel
How do I use the dot operator if a column has empty cell?
I want to use this formula for example:
=IF(XLOOKUP(A2,A:.A,B:.B,"")="","Not Ready",XLOOKUP(A2,A:.A,B:.B,""))
I put the dot operator to trim trailing cells. The problem is that B5 is empty and the formula is giving me an error. If I put a value in B5 then it works.
How can I make it work as long as A5 has a value?
u/logix56333 — 9 days ago