Forum Discussion
Solved
Help with a if formula
I am trying to set a value based off if it its equal to a bank of words. How to i make a if statement so that the if for example x= something from a word bank then it equals the corresponding y from ...
=INDEX(Rangers!$B$2:$B$27,MATCH(Oyster!C2,Rangers!$C$2:$C$27,0))This can be done with INDEX and MATCH.
=INDEX(Rangers!$B$2:$B$27,MATCH(Oyster!C2,Rangers!$C$2:$C$27,0))This can be done with INDEX and MATCH.
- Thanks a bunch that did what I wanted. I will have to remember this formula. I know I will be using it a bunch in the future.
