Excel to return a value in a column, if multiple criteria meets

[Ann Ooi]

I tried to return a value in sheet1, column A (vertical), to sheet 2 (Horizontal format), if the "Process_Step" and "WO" is matched. As the data is huge and there're many columns, I do not know how to specifically to use the index and match or vlookup, to return the column A value (Date) if the criteria are meet. The INDEX formula I written, is not working as I understand it's not making sense to Excel. [=IF(INDEX(WIP!$A$1:$W$8835,MATCH($B3,WIP!$U:$U,0),MATCH(C$2,WIP!$L:$L,0)),C3=WIP!$A:A,"")]

 

[Ann Ooi]

Hi Alan, Need help on Power Query code again. I added new data and it cannot run, as following error shown.
How to get a dynamic code, so that the pivot column automatically refresh or get the new data added in?

 

[Ann Ooi]

Hi, why Power Query not able to refresh or auto capture new lines added in source? I must click inside the table to refresh only? not able to refresh the connection? Is there anything I missed out or any simpler steps to do this? I'm really new on this, really need help.

 

[alansidman]

Cannot determine issue from pictures shown.