Forum Discussion

Rangerrick22's avatar
Rangerrick22
Copper Contributor
Apr 10, 2022
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 ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Apr 10, 2022

    Rangerrick22 

    =INDEX(Rangers!$B$2:$B$27,MATCH(Oyster!C2,Rangers!$C$2:$C$27,0))

    This can be done with INDEX and MATCH. 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Apr 10, 2022

Rangerrick22 

=INDEX(Rangers!$B$2:$B$27,MATCH(Oyster!C2,Rangers!$C$2:$C$27,0))

This can be done with INDEX and MATCH. 

  • Rangerrick22's avatar
    Rangerrick22
    Copper Contributor
    Apr 10, 2022
    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.

Resources