Formula Error When Control Box Checked

  • I have a formula that bring me back a figure (cell I3 attached) based on underlying data which works fine until I use the control box I have created to select the other option "poly". If this is checked then I just get an error and I cannot work out why.


    Can anyone help me at all please?

  • Re: Formula Error When Control Box Checked


    The MATCH formula is returning #N/A
    You need to fix that first. If you want a nearest match then change the 3rd argument to 1

    [h4]Cheers
    Andy
    [/h4]

Participate now!

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