Hi all,

Thanks in advance for any help you can give me.

I'm a bit stuck working on organising some data, here's a quick rundown of my setup.

Sheet 1 - Bascially just a list of participants

Column A - Surname, Column B - First name, Column C - True if in the control group, blank if not.

Sheet 2 - Data from a survey
Column A - Surname, Column B - First name, Column C - Return the value as in sheet 1

This is where I'm stuck. I want to take the names from sheet 2 and check if they are in sheet 1. If they are in sheet 1, and column C is TRUE, then I would also like column C to return true in sheet 2.

Using =IF(AND(IF(COUNTIF(Sheet1!$A$2:$A$118,$A3),TRUE),IF(COUNTIF(Sheet1!$B$2:$B$118,$B3),TRUE)),IF(Sheet1!$C3=TRUE, TRUE,"")

I get the value in sheet 2 based on the row position being true, what i really want is for the value to be returned next to the name.

Hopefully that's not too confusing, my head is in a mess from staring at it too long.

Cheers,
Scott