Forum Discussion
Solved
Multiple IF formula calucation
Hi All, I have a 2 datasets similar to the below. Data Set 1 Pressure Plume Size Flowrate (kg/hr) Flowrate (T/hr) Save Value (k$/yr) 3 0.5 3 1 ...
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 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.