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.
5 Replies
=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.
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.
