locked
INDEX MATCH Formula Help RRS feed

  • Question

  • Hello everyone,

    I've been trying to create an Excel formula and for some reason the formula isn't cooperating. The objective of the formula is to match an employee ID from a list, then match dates from a table on the same worksheet, and then return the production / value found under the specific date to another worksheet. I want to extract the value from the worksheet (EMPProd1) and show this value on another worksheet called ( Log Book).

    Below are two separate formulas that I've tried so far and in theory they should work, but for some reason they don't. Can someone please help me? 

    =INDEX(EMPProd1,MATCH('Log Book Temp.'!BC1,EMPProd1[[#All],[RACF]],MATCH(EMPProd1[[#All],[RACF]],0)

    =INDEX(Table2[#All],MATCH(BC1,Table2[RACF])*(BD33,Table2[#Headers]),0)

    Thank you,

    Brian P.


     

    8.5.1
    Monday, October 19, 2020 1:29 PM