Oct 19 2021 10:03 AM - edited Oct 19 2021 10:53 AM
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.
Oct 19 2021 10:15 AM
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.
Oct 19 2021 11:02 AM
=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.
Oct 19 2021 12:50 PM - edited Oct 19 2021 12:55 PM
Oct 19 2021 12:50 PM - edited Oct 19 2021 12:55 PM
The Answer is showing "N/A"
Oct 19 2021 01:08 PM
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.
Oct 21 2021 02:13 AM