Index Match question I think

[TyeReece]

I have two worksheets. Table 1 is of unique records. Table 2 is a table of conditions that may or may not match up with a unique record. Look like this:
Table 1
ID Attention Deficit PTSD Bipolar Schizophrenia
1
2
3
4
5

Table 2
ID Diagnosis
1 Attention Deficit
1 PTSD
3 Bipolar
4 PTSD
4 Bipolar
4 Schizophrenia
5 Attention Deficit
5 Bipolar

What I want to do is put a "true" or the Diagnosis name from Table 2 in column 2 of Table 1, if there is a record that matches the ID in Column A Row 2 of Table 1 and matches the diagnosis in Cell B2 of Table 1. The formula I am using (=IF($A2<>"",VLOOKUP($A2,'All Dx During Tx'!$A$2:$B$2021,MATCH(DJ$1,Columns,0),FALSE),"")) returns IF there is a matching ID but does not specify the diagnosis. Thanks in advance.

 

[Marcelo Branco]

Try something like this

	A​	B​	C​	D​	E​	F​	G​	H​
1​	ID​	Attention Deficit​	PTSD​	Bipolar​	Schizophrenia​		ID​	Diagnosis​
2​	1​	x​	x​				1​	Attention Deficit​
3​	2​						1​	PTSD​
4​	3​			x​			3​	Bipolar​
5​	4​		x​	x​	x​		4​	PTSD​
6​	5​	x​		x​			4​	Bipolar​
7​							4​	Schizophrenia​
8​							5​	Attention Deficit​
9​							5​	Bipolar​
10​

Formula in B2 copied across and down
=IF(COUNTIFS($G:$G,$A2,$H:$H,B$1),"x","")

Hope this helps

M.

 

[TyeReece]

That is it! Looks like I was trying to make it harder than it had to be. Thanks!