vLookup not working.

  • Hi. Please help. I am using a vlookup. =VLOOKUP(B4,'data1'!$G$1:$AN$10000,4,FALSE)


    B4 is a Sum which adds a date a time together.


    =SUM($A$1+Lists!D1)


    The aim is to look up data by half hourly interval. It works on 9 instances but i get #N/A on all other instances.


    Please help this is driving me crazy.

  • Re: vLookup not working.


    Why does the range need to be so wide? It could be just 'data1'!$G$1:$J$10000.


    [sw]*[/sw]

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules