Forum Discussion
Mapping Table
What Function Should I use for this to get the OUTPUT value.
- 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 🙂
