Forum Discussion
How to Find the Z Factor From the List
Below I attached the excel list and please help to find the Z Factor From the List When We Enter the Temperature & Pressure In the particular Cell the Z factor is lookup from the list.
=INDEX(E2:E15,MATCH(1,(A2:A15<=H4)*(B2:B15>=H4)*(C2:C15<=I4)*(D2:D15>=I4),0))
I removed the merged cells in columns H to J and then entered above formula with ctrl+shift+enter and it seems to work.
The Answer is showing "N/A"
In my sheet it shows "1,0017". Did you enter formula as matrix with ctrl+shift+enter? This puts the curly brackets { } around the formula.
