• Hi Folks

    I'm playing with the XLOOKUP function at the moment but have run into a problem. If I just use two nested XLOOKUP's it works fine, but as soon as I enter a third XLOOKUP I get a #VALUE error

    Can someone give me some guidance and help please?? I've attached a sample so that you can see where I'm going wrong

    Thank you.

    Kind regards



  • Explain what you are trying to achieve.

    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

  • Hi Ali.

    It's good to hear from you, thank you for responding.

    The idea is to look at the date in cell M4 and match that to row D1:I1, look at the Criteria in Cell L10 and match that to column C4:C34, also look at the Version number in cell N9 and match that row D2:I2, then return the value from D4:I34.

    In the example the result in Cell N10 should be: 565

    I hope this helps, (and makes sense...)

    Kind regards


  • Maybe?


    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!