How to Find the Z Factor From the List

%3CLINGO-SUB%20id%3D%22lingo-sub-2862094%22%20slang%3D%22en-US%22%3EHow%20to%20Find%20the%20Z%20Factor%20From%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862094%22%20slang%3D%22en-US%22%3E%3CP%3EBelow%20I%20attached%20the%20excel%20list%20and%20please%20help%20to%20find%20the%20Z%20Factor%20From%20the%20List%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2862094%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2862120%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Find%20the%20Z%20Factor%20From%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156901%22%20target%3D%22_blank%22%3E%40ajmal%20pottekattil%20yoousuf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%20Community%20Discussion%20space%3C%2FA%3E%3CSPAN%3E%2C%20%3C%2FSPAN%3Ewhich%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2862385%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Find%20the%20Z%20Factor%20From%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156901%22%20target%3D%22_blank%22%3E%40ajmal%20pottekattil%20yoousuf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DINDEX(E2%3AE15%2CMATCH(1%2C(A2%3AA15%26lt%3B%3DH4)*(B2%3AB15%26gt%3B%3DH4)*(C2%3AC15%26lt%3B%3DI4)*(D2%3AD15%26gt%3B%3DI4)%2C0))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20removed%20the%20merged%20cells%20in%20columns%20H%20to%20J%20and%20then%20entered%20above%20formula%20with%20ctrl%2Bshift%2Benter%20and%20it%20seems%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2862801%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Find%20the%20Z%20Factor%20From%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862801%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Answer%20is%20showing%20%22N%2FA%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2862904%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Find%20the%20Z%20Factor%20From%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862904%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156901%22%20target%3D%22_blank%22%3E%40ajmal%20pottekattil%20yoousuf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20my%20sheet%20it%20shows%20%221%2C0017%22.%20Did%20you%20enter%20formula%20as%20matrix%20with%20ctrl%2Bshift%2Benter%3F%20This%20puts%20the%20curly%20brackets%20%7B%20%7D%20around%20the%20formula.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2868561%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Find%20the%20Z%20Factor%20From%20the%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2868561%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174419%22%20target%3D%22_blank%22%3E%40Quadruple_Pawn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20enter%20the%20formula%20in%20the%20particular%20column%20%2Cbut%20it%20is%20not%20getting%20properly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

@ajmal pottekattil yoousuf 

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. 

@ajmal pottekattil yoousuf 

 

=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"

@ajmal pottekattil yoousuf 

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.

@Quadruple_Pawn 

I enter the formula in the particular column ,but it is not getting properly.