Forum Discussion

null null's avatar
null null
Copper Contributor
Feb 06, 2018

VLOOKUP isn't working for LOTS of data

I have a workbook with 4 sheets (Search, Active1, Active2 and Inactive).  Search is where the user will enter an NPI# to search the other 3 worksheets for EVERY appearance of that NPI#, presenting da...
Formulas & Functions
Need Help
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Feb 06, 2018

    VLOOKUP() works perfectly. But you should change the sheet name from Acitve1 to Active1 to reflect the sheet name used in C2, D2 and F2.

    And E2 and E3 don't have formulas at all.

     

    • null null's avatar
      null null
      Copper Contributor
      Feb 06, 2018

      Thank you for looking at the formulas.  I can see how I wrote those two incorrectly. 

       

      You are correct!  There is no data in those two cells because there is no data to retrieve and will always be #N/A.

       

      Where I continue to run into problems is when I use these exact formulas on all 120,000 rows (across the 3 spreadsheets).  Any thoughts on this?

       

      I really appreciate your discerning eye and feedback.

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Feb 06, 2018

        What exactly are your problems?