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.
That could be like
=XLOOKUP(Pressure & "=" & PlumeSize,
DataSet2Pressure & "=" & DataSet2PlumeSize,
DataSet2FlowRate,"not found")in Data Set 1 FlowRate column cell, drag it to the down. Similar for other ones.