Hi Excel gurus!
I receive a report that has mixed data in that some users have one row of data and some have two. I'm trying to extract one piece of data from multiple lines for a user.
For example - this is the "lookup" report:
User ID Outcome Date Assigned
1234 COMPLETE 10/22/2018 13:23:47
1234 APPROVE 10/22/2018 13:17:28
This is my core report:
I want to use formulas to lookup against User ID on the lookup report:
--Col B - If Outcome contains "Approve," put "Approve"
--Col C - If Outcome contains "Approve," put the Date info from Date Assigned
I hope that makes sense - and thank you in advance for the help!
I receive a report that has mixed data in that some users have one row of data and some have two. I'm trying to extract one piece of data from multiple lines for a user.
For example - this is the "lookup" report:
User ID Outcome Date Assigned
1234 COMPLETE 10/22/2018 13:23:47
1234 APPROVE 10/22/2018 13:17:28
This is my core report:
I want to use formulas to lookup against User ID on the lookup report:
--Col B - If Outcome contains "Approve," put "Approve"
--Col C - If Outcome contains "Approve," put the Date info from Date Assigned
I hope that makes sense - and thank you in advance for the help!
