Which formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-3428014%22%20slang%3D%22en-US%22%3EWhich%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3428014%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20of%20rates%20as%20below.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CThomson_E_0-1653488710607.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22CThomson_E_0-1653488710607.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22CThomson_E_0-1653488710607.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22CThomson_E_0-1653488710607.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F374962i718FA4255C8B9338%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CThomson_E_0-1653488710607.png%22%20alt%3D%22CThomson_E_0-1653488710607.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EOn%20another%20sheet%2C%20I%20would%20like%20it%20to%20select%20the%20correct%20rate%2C%20depending%20on%20the%20Trade%20and%20if%20Day%20or%20Night%20shift.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CThomson_E_1-1653488798860.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22CThomson_E_1-1653488798860.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22CThomson_E_1-1653488798860.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22CThomson_E_1-1653488798860.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F374963i11CBA71BA3C03EB3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CThomson_E_1-1653488798860.png%22%20alt%3D%22CThomson_E_1-1653488798860.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ECan%20anyone%20assist%20with%20the%20formula%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3428014%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3428307%22%20slang%3D%22en-US%22%3ERe%3A%20Which%20formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3428307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1401244%22%20target%3D%22_blank%22%3E%40CThomson_E%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DINDEX('table%20of%20rates'!%24B%242%3A%24C%2418%2CMATCH(Tabelle1!%24C2%2C'table%20of%20rates'!%24A%242%3A%24A%2418%2C0)%2CMATCH(%24E2%2C'table%20of%20rates'!%24B%241%3A%24C%241%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EMaybe%20with%20this%20formula.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a table of rates as below.  

CThomson_E_0-1653488710607.png

On another sheet, I would like it to select the correct rate, depending on the Trade and if Day or Night shift.

CThomson_E_1-1653488798860.png

Can anyone assist with the formula?

Thanks in advance

1 Reply

@CThomson_E 

=INDEX('table of rates'!$B$2:$C$18,MATCH(Tabelle1!$C2,'table of rates'!$A$2:$A$18,0),MATCH($E2,'table of rates'!$B$1:$C$1,0))

Maybe with this formula.