Nested IF statement within a index match

[Pika735]

I have a data set where the data looks like this

Bad Actor	date	ID
Good Actor	date	ID
Neutral Actor	date	ID

I need to be able to match the date of the bad actor and only the bad actor linked with the ID on a new sheet. I tried a few variations of IF statements with an index match, but I wasn't getting the date.

The problem lies in that the same ID can be linked with all three, but I only need one, the bad actor. Any help would be appreciated!

 

[Alex Blakenburg]

If you mean that you want to use the above column 1 and column 3 to lookup another sheet and return the value for colummn 2, then either give us an XL2BB for both the above and the other sheet.
If you can't do XL2BB we need the column letters for the above and the name of the other sheet and the column references in the other sheet for Bad Actor, ID & Date.
My preference would be to use =Lookup(2,1/(expression1*expression2),lookuparray)