Forum Discussion
Rangerrick22
Apr 10, 2022Copper Contributor
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 a word bank? Im trying to get a if statement so that if the value in C column on the left equals the C column on the right then the B column equals the corresponding B value that the C column is equal to on the right other wise leave blank.
=INDEX(Rangers!$B$2:$B$27,MATCH(Oyster!C2,Rangers!$C$2:$C$27,0))
This can be done with INDEX and MATCH.
2 Replies
- OliverScheurichGold Contributor
=INDEX(Rangers!$B$2:$B$27,MATCH(Oyster!C2,Rangers!$C$2:$C$27,0))
This can be done with INDEX and MATCH.
- Rangerrick22Copper ContributorThanks 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.