SOLVED

Mapping Table

Copper Contributor

 

What Function Should I use for this to get the OUTPUT value.

 

GuruBMW_0-1650615474473.png

 

 

 

4 Replies
best response confirmed by GuruBMW (Copper Contributor)
Solution

@GuruBMW 

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

For example INDEX and MATCH. 

Thanks a lot for your great help!!
If you are using Excel 2019 or later, it is worth your while to learn XLOOKUP. It is a little easier to use and get used to. It is nice too, that it defaults to the exact match.
=XLOOKUP(A2,$D$5:$D$8,$E$5:$E$8)
Fill down to the other cells.
Or, do them all at once with:
=XLOOKUP(A2:A25,$D$5:$D$8,$E$5:$E$8)
Thank you @ Eric_Collins5 and introducing me to XlookUp 🙂
1 best response

Accepted Solutions
best response confirmed by GuruBMW (Copper Contributor)
Solution

@GuruBMW 

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

For example INDEX and MATCH. 

View solution in original post