I have a sheet where I am tracking labor based on another sheet where the labor is exported.
What I am trying to do is pull the date from the labor sheet that matches the order AND the task.
On the labor sheet the Date in column A. The order # in in Column I and the task is in Column M
It looks like this.
Date BlahBlah BlahBlah BlahBlah BlahBlah BlahBlah BlahBlah BlahBlah Order BlahBlah BlahBlah BlahBlah Task 4/13/2017 ABCD General Production Tasks
On my main sheet i have all the tasks possible in the header so for example.
Order # is in column A, in this case lets say ABCD is A2
General Production tasks is in my header as B1
In B2 I would like a formula to check my labor sheet and match the order # A2 with the task B2 and return the date that it was completed on. The end result here would be 4/13/2017.
I can upload a sample workbook if needed but i feel like this is probably an easy formula and i am just messing something up.