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.


    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.


    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