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.
You may use INDEX MATCH function with multiple criteria.