Forum Discussion
Multiple IF formula calucation
Serdet As indicated in my previous post, I used some named ranges (dataset2, headers, pressure and plume size). This makes the formula easier to write, read and maintain. Added them to your sheet. See attached.
Serdet In case the suggested solution with XLOOKUP is not supported by your Excel version, the use of INDEX and MATCH is demonstrated in the attached file. I used some named ranges to make the formulae easier to write, read and maintain.
Thanks for getting back to me. I have tried to implement the formular used in your spreadsheet but are having problems due to my 'dataset2' being located on a different 'Tonnage' tab.
Please see the attached.
Many thanks,
Elliot
Serdet Cutting a few corners here, because it can be done better. just don't have the time right now, but the attached file contains working formulae. Note that I also added the named ranges required.
Hi Riny_van_Eekelen,
Thank you for sending that over. I have copied your formula into my spreadsheet but are receiving a #NAME? error.
I have double-checked the two but cannot spot any differences. Any ideas on where I might be going wrong?
Many thanks,
Elliot
