Return Another Cell If One Cell Equals Number?

[JMITCH26]

I'm trying to get Cell E4 to look at Cell C3.
Then take the number from C3 and find the equal number from list of numbers B21:B30.
Then report back the percentage from the list next to that number.

Cells
C3 = 8

Cells
B21 = 1
B22 = 2
B23 = 3
B24 = 4
B26 = 5
B26 = 6
B28 = 7
B29 = 8
B30 = 9
B31 = 10

Cells
C21 = 7%
C22 = 9%
C23 = 14%
C24 = 17%
C26 = 21%
C26 = 24%
C28 = 28%
C29 = 31%
C30 = 35%
C31 = 39%

Example:

If Cell
C3=8

Then
E4=31%

any help on this will be great thank you.

 

[Michael M]

USe

=VLOOKUP(C3,$B$21:$C$30,2,0)

 

[JMITCH26]

Thank you that works great.

 

[Michael M]

glad to help....