Mapping Table

[GuruBMW]

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

[#2 · Accepted solution]

@GuruBMW 

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

For example INDEX and MATCH. 

[#3]

Thanks a lot for your great help!!

[#4]

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)

[#5]

Thank you @ Eric_Collins5 and introducing me to XlookUp :)