Formula that allows another formula to be used if the first formula results in NA. I have 2 columns that contains companies with names that are similar. Eg Column A: ABC Pte. Ltd., Column B: ABC Holdings. Another data that I have to map to will be a Officer in charge name. I am currently using INDEX MATCH MATCH formula. Is there a way that I can insert 2 formulas in one cell, where if the first formula results in NA or ERROR, the cell will use the 2nd formula to search?
Bookmarks