Mapping Table

New Contributor


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






4 Replies
best response confirmed by GuruBMW (New Contributor)



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.
Fill down to the other cells.
Or, do them all at once with:
Thank you @ Eric_Collins5 and introducing me to XlookUp