Forum Discussion
Solved
Formula using IF ISNUMBER and SEARCH functions
Hello there,
Is it possible to look (or search) for specific text in a column (Column A), and if that text is found, take the number that is in Column B (same row) and place it in Column C. If the text is NOT found, then take the number that is in Column B (same row) and place it in Column D.
4 Replies
@Detlef Lewi
Hello again,
It's probably more complicated that the very simple table I previously attached:
With the more complicated table, the result I want is:
Look for the text OR, or RAILEX (in column B), if FOUND, then take the NUMBER in column C and place it in column D. If OR, or RAILEX (in column B), is NOT FOUND, then take the NUMBER in column C and place it in column E.
Hope this makes sense.
