Results 1 to 9 of 9

vlookup with scroll bar not quite working

Threaded View

ternt vlookup with scroll bar not... 05-18-2017, 06:58 PM
Glenn Kennedy Re: vlookup with scroll bar... 05-19-2017, 03:55 AM
TMS Re: vlookup with scroll bar... 05-19-2017, 04:56 AM
Glenn Kennedy Re: vlookup with scroll bar... 05-19-2017, 05:05 AM
TMS Re: vlookup with scroll bar... 05-19-2017, 06:09 AM
ternt Re: vlookup with scroll bar... 05-21-2017, 07:23 PM
Glenn Kennedy Re: vlookup with scroll bar... 05-22-2017, 04:38 AM
ternt Re: vlookup with scroll bar... 05-22-2017, 06:26 PM
Glenn Kennedy Re: vlookup with scroll bar... 05-23-2017, 02:07 AM
  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    7

    vlookup with scroll bar not quite working

    Hi everybody!
    In the attached file i'm trying to have a scrolling list. the problem is that the vlookup is returning #N/A if the scroll value is not divisble by 3. The same lookup value returns a result at different increment values. I can resolve this by having the scroll increment in units of 3 but i would like to know what the problem is.
    Last edited by ternt; 05-22-2017 at 06:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Indirect working on current cell, but not when I scroll down
    By bjcowen9000 in forum Excel General
    Replies: 13
    Last Post: 02-03-2016, 05:42 AM
  2. Pivot Table Scroll not working
    By TroyA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2015, 05:50 PM
  3. Userform with scroll bar not working as expected
    By bigfishprf in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2015, 03:43 PM
  4. Scroll not working in Excel
    By bdcelli in forum Excel General
    Replies: 3
    Last Post: 03-24-2014, 12:28 PM
  5. [SOLVED] Vertical Scroll not working. Excel
    By Cyberpawz in forum Excel General
    Replies: 1
    Last Post: 06-05-2012, 09:43 AM
  6. Object sheet name and scroll limit not working.
    By HuggyBear in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2005, 12:40 PM
  7. how to prevent worksheet scroll bar to be bigger than working are.
    By Worksheet AREA in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1