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