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.
Bookmarks