Forum Discussion

GuruBMW's avatar
GuruBMW
Copper Contributor
Apr 22, 2022
Solved

Mapping Table

  What Function Should I use for this to get the OUTPUT value.        
  • OliverScheurich's avatar
    Apr 22, 2022

    GuruBMW 

    =INDEX($E$5:$E$8,MATCH(A2,$D$5:$D$8,0))

    For example INDEX and MATCH. 

Resources