Hi There,
I would like to know if there is an excel formula which can be used to search for specific values within a pair of cells.
As you can see from the attached picture, I have used the IF(ISNUMBER(SEARCH function to indicate which cells contain the words 'Learner' or 'Site Admin', otherwise it displays 'N/A'.
What I would like is if there were a function which searches column A to determine if it has a value of 1.2; if so I want to then search column B to determine if it has one of the two values specified.
In other words, If A4 = 1.2 and B4 contains Learner or Site Admin then I want C4 to display Learner or Site Admin.
Is this possible?
Thanks!
I would like to know if there is an excel formula which can be used to search for specific values within a pair of cells.
As you can see from the attached picture, I have used the IF(ISNUMBER(SEARCH function to indicate which cells contain the words 'Learner' or 'Site Admin', otherwise it displays 'N/A'.
What I would like is if there were a function which searches column A to determine if it has a value of 1.2; if so I want to then search column B to determine if it has one of the two values specified.
In other words, If A4 = 1.2 and B4 contains Learner or Site Admin then I want C4 to display Learner or Site Admin.
Is this possible?
Thanks!