MissV,Arrrrh, the old shift,ctrl,entre trick....yep...missed it...

  1. Up
    1,169 Posts.
    lightbulb Created with Sketch. 3
    MissV,
    Arrrrh, the old shift,ctrl,entre trick....

    yep...missed it by .-----. that much

    Got a demo working now (a rejig of your index / match)



    Must try the old 'figure up nose, whilst turning clockwise' enter, trick. Pahaps then my vlookup variable will work.......who ever creates these syntax must have a warped brain.

    Thanks again
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.