Solve : Excel Vlookup cell reference is a formula - should work but it

1.	Solve : Excel Vlookup cell reference is a formula - should work but it doesn't?
Answer» 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. 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.Thanks, it worked ! Also FOUND another way =value(right (a1, 1))

Discussion