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.
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
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.
Hi Riny_van_Eekelen ,
Sorry to bother you again. I have implemented the formula into the attached excel spreadsheet and are revieving errors.
I have tried renaming the cell selections but have had no luck. Any tips?
Many thanks,
Serdet I assume you refer to the errors in columns P, Q and R. Fixed the formulae in these columns and copied the headers in P2:R2 to C1:E1 in the Tonnage sheet. These headers must be exactly the same, otherwise the MATCH will not work.
If you want to get rid of the remaning #N/A's (due to the fact that there are no values for Pressure and Plume size), wrap the entire formula in =IFERROR(INDEX(...........),"").
- Thank you very much. I was assuming the C$2 referred to the column located in the separate 'Tonnage' tab.
- Thank you very much for your help! Have a good day