I need a formula that will search through a spread sheet to find a word in one column and once it finds that word it will search the row for another identical match. If both match, then it will = the answer in another column within the same row as the answer.
Two requirement for a specific answer.
Solved by X. J. in 23 mins