Hello,
I am working on an output file that lists a number of different data points. I am hoping to use an equation that looks within a specific cell for text. If it finds that text, then return a value in another cell. While that is pretty easy, I am looking for the equation to basically return certain data based on different names it finds. So f it sees Hello Chris, then return just Chris in column B. If it sees Hello Brad, then return Brad, etc. I was thinking of doing an IF statement, but thought I might run into a nesting issue. Any suggestions?
Column A Column B
Hello Chris Chris
Hello Jeff Jeff
Hello Brad Brad
Hello Larry Larry
Hello Mike Mike
Hello Red Red
Hello Orange Orange
Hello Blue Blue
Hello Green Green
Bookmarks