Question:

Problem using Vlookup please help me?

by  |  earlier

0 LIKES UnLike

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:

   Report

2 ANSWERS


  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.


  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.

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.