Copying data from a cell if two other cells match specific criteria

[Rhys Lewis]

Hi all,

I am trying to get my spreadsheet to copy data from a specific cell if two other cells match a specific criteria.

Could anyone assist?

[TABLE="width: 1016"]
<tbody>[TR]
[TD]Surname[/TD]
[TD]First Name[/TD]
[TD]Date[/TD]
[TD]First Activity[/TD]
[TD]Last Activity[/TD]
[TD]Log In[/TD]
[TD] Log Out[/TD]
[TD] Total Minutes[/TD]
[/TR]
[TR]
[TD]Addis[/TD]
[TD]Neil[/TD]
[TD]Wednesday 03-Jan[/TD]
[TD]08:41 (Access Granted)[/TD]
[TD]17:46 (Exit Granted)[/TD]
[TD="align: right"]03/01/2018 08:41[/TD]
[TD="align: right"]04/01/2018 00:00[/TD]
[TD="align: right"]09:04[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col></colgroup>[/TABLE]


So I would like to copy the data from First Activity (D2) if Surname (A2) contains "Addis" & Date (C2) contains "03-Jan". I just can't figure out what formula I should be using!

Any help would be greatly appreciated.

 

[Special-K99]

Contains ADDS, do you mean CONTAINS or EQUALS ?
Maddsing CONTAINS adds but does not EQUAL it.
I'm assuming EQUALS.

No year supplied for that date so I guess the year is irrelevant for comparing.

Try
=IF(AND(A2="Adds",TEXT(C2,"dd-mmm")=""03-Jan"),D2,"")