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?
Tags: