I need to write an IF Statement to fill cell in Column C with the same number found in Column B, IF the cell in Column A contains the word "Pending". I can do this with no problem if Column A cell just says "Pending", HOWEVER Column A will never ONLY say "Pending"; whenever the cell in Column A contains the word pending, it will always include additional words; so I cannot figure out how to write the IF statement. Any help is appreciated.
Bookmarks