Vlookup #NA Error

[jacob1985]

Can someone help shed some light on an #NA error I am receiving with a Vlookup formula?

I am trying to help users interpret account codes. I have a 10 digit accounting string and the 10th number tells the user what type of activity the funds will be used for.

-I used =MID(B3,10,1) to reference the string and pull the 10th digit out and display it in cell C4. The digits would only be 1, 2, 3, 4, or 5.
-I then use =VLOOKUP(C4,A32:B36,2,FALSE) to display the type of funding activity, but I keep getting an #NA error.
-For table A32:B36, I have the rows in column A numbered 1-5, and the rows in column B are the titles of each activity.
-The #NA error does not appear when I use the same methodology and formulas for the 4th, 5th, or 8th digits in the account string.
-When i overwrite the MID formula with the number 4, the Vlookup formula works perfectly.

Any help would be GREATLY appreciated. Thanks!

 

[Marcílio_Lobão]

jacob1985, Good evening.

Remember that MID function results an TEXT as answer.

Try to use:

C4 --> =MID(B3,10,1)*1

Is that what you want?

I hope it helps.

 

[jacob1985]

Yes, that worked perfectly! Thank you very much!!

 

[Marcílio_Lobão]

jacob1985, Good morning.

Glad to have helped you.

Thanks for the feedback.