Excel Vlookup cell reference is a formula - should work but it doesn't

[meccagza]

I set up my spreadsheet like this:

A                              B                            C
Team #1               =Right(A1, 1)             =Vlookup(B1, Range, 2, false)

Team #1                 1                                #N/A

The range is listed as such

Team                   Name
1                         Rockets

In the Vlookup I keep getting #NA errors, if I substitute the cell reference B1 to the number 1, it works, and if I change cell B1 from a formula to the number 1 it also works. When I evaluate my formula step by step, it gives me this: Vlookup("1", range, 2, false) and then the next step gives me an error.  I need help because I can't find my error, and I think it should work with a formula, been working on this for hours.   

[oldun]

If you change the formula in B to: =RIGHT(INT(A1),1)
or the formula in C to: =VLOOKUP(INT(B1),Range,2,False)
it should give you the expected result.

[meccagza]

Thanks, it worked ! Also found another way

=value(right (a1, 1))