The column values will only be <Blank>, In-Flight, Changes Required or Validated. This should be no need to return Review if the logic holds.Column M also contains 210 cells that return #N/A error value. Consider the case when column B contains BKCY.PAY.1.2. On row 19 column M has "Changes Required", while on row 29 it has #N/A error value. The column M values don't match, so my formula returns "Review". I think it better to continue returning "Review" until your issues with #N/A are addressed.
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Excel Formula to split product code | 5 | 16 | |
Excel file that does not ask to be saved before exiting | 6 | 22 | |
Excel 2010: Creating a "Yes" or "No" Pop-Up | 20 | 42 | |
Excel, covert column titles to row titles and back | 2 | 13 |
Join the community of 500,000 technology professionals and ask your questions.