I have the following information in a table
C D
----------- -----------
1 | 25% | 1 |
----------- -----------
2 | 50% | 2 |
----------- -----------
3 | 75% | 3 |
----------- -----------
4 | 100% | 4 |
----------- -----------
If a user inputs into a cell (A1) any of the values in column D, cell (B1) will display the number in column C.
I am using the following function to acheive this
=IF(A1=D1,C1,IF(A1=D2,C2,IF(A1=D3,C3,IF(A1=D4,C4))))
Is there a shorter way to do this using a different function?