Problem using Vlookup please help me?

Question

I have used "Mid" function in Cell D5 to find a numeric value the formula was =Mid(A5,8,1).and then in E5 I have entered =VLOOKUP(D5,SPEC2BRN.csv!$A$2:$B$10,2) [it will find data from a external file] but gives an error #N/A. But if I put the value in D5 manually it works well. But what Can I do now?

Answer 1

Well, for one thing you want to change it to =VLOOKUP(D5,SPEC2BRN.csv!$A$2:$B$10,2,1) to look for an exact value, but that shouldn't cause the #N/A! error.

Answer 2

the vlookup() obiously works fine(i wouldnt mess with it).  good job testing it for us.

i think the problem is in D5

your formula will just pull the 8th character.  but thats not what you want...you want to convert the number to  a value.

so copy&paste this in D5

=VALUE(MID(A5,8,1))

let me know if you still have problems.