Forum Discussion

Deleted's avatar
Deleted
Mar 06, 2018

Vlookup not working properly

I'm a novice user, and this is my first post, so not sure i'm even doing this right. I feel I have my formulas right and Vlookup is not pulling the info. 

 

I have a schedule where depending on time, I can pull a different set of speakers and change the length of sessions. By changing the Program number in A4 from 1, 2 or 3, it should pull a different schedule from my DB. But I get #N/A when it should be returning values. Depending on what program I use, It shows more results. I'm not sure what I'm doing wrong. I have Excel 2010

 

I'm using (=VLOOKUP($A4,DB!$A$3:$I$16,2,FALSE)) as my formula

 

Attached is my file. Thanks for your help

 

Dan

Formulas & Functions
Need Help
  • Tinn Keeper's avatar
    Tinn Keeper
    Brass Contributor
    Mar 06, 2018
    Hi Dan,
    You can try to copy the values from tabsheet 'Sch' to tabsheet 'DB'. Problably the 2,3 is not exactly the same in both tabsheets.
    Kr
    TK
    • Deleted's avatar
      Deleted
      Mar 06, 2018

      I that's how I created the fields. It still won't work

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Mar 06, 2018

        Dan, that's binary representation. If you try

        =VLOOKUP((2.1+0.1),DB!$A$3:$G$16,2,FALSE)

        works,

        =VLOOKUP((2.2+0.1),DB!$A$3:$G$16,2,FALSE)

        doesn't work, but

        =VLOOKUP(2.3,DB!$A$3:$G$16,2,FALSE)

        works

         

        I'd suggest to round as in previous post

         

Resources