VLOOKUP Not returning proper values

[KevinZ]

I currently have a spreadsheet that aggregates values from other spreadsheets using VLOOKUPS. On this aggregated spreadsheet, I have numerous columns that I want to add a custom value to in a separate column. The values returned from the underlying spreadsheets are #N/A, 1, 2, 3, T1, T2, T3, etc. These can be up to approx. 1000 or T1000. I am using a VLOOKUP to create a custom value #N/A = 0, 1 to 10 = 1, T1 to T10 = 1, 11 to 20 = 2, T11 to T20 =2, etc. I have created a separate spreadsheet with the values I have assigned. Note, Each call will only have 1 value.

I am getting a Value not Available error on the cells.
For example, I have a value of 8 in a target cell.
The formula evaluation appears to be correct: VLOOKUP("8",'Ranking 1'!A:B,2,False)
In the Ranking 1 spreadsheet, I am assigning a value of 5. The VLOOKUP is displaying the error and a #N/A in the field.

 

[KevinZ]

That worked. Thank you both so much. Looks like I need to research IFERROR to understand it better.

 

[Fluff]

Glad we could help & thanks for the feedback