I'm using =XLOOKUP formula and here is my formula
=XLOOKUP(C:C,C:C,A:A) . So the value that i want to get is in Column A. now if there is no value in Column A i want the text "N/A" instead. what formula should i use or add to my =XLOOKUP formula?
=XLOOKUP(C:C,C:C,A:A) . So the value that i want to get is in Column A. now if there is no value in Column A i want the text "N/A" instead. what formula should i use or add to my =XLOOKUP formula?