populate cell based on cell values in same row

[theonlyhamish]

Hi folks, first time be gentle lol. Ive had a look at similar questions but im still not managing to get this one.

Im trying to populate column J (this year) based on the specific values in columns B (type), E (date last visit), G (score) and H (urgent) in the same row.

so in my simplistic nature - if B=(a,b,c) + E is less than 1-4-21 + G=3 and H=(HIGH, MEDIUM) the J displays 'Y'

Ive looked at versions of Vlookup and If criteria but im spiraling lol ... any help would be fantastic.

 

[Special-K99]

By this

if B=(a,b,c) + E is less than 1-4-21 + G=3 and H=(HIGH, MEDIUM) the J displays 'Y'

do you mean this?

If B = a or b or c and E is less than 1-4-21 and G=3 and H= High or Medium then J display Y

If so then try

in J2
=IF(AND(OR(B2="a",B2="b",B2="c"),E2<"01-04-21",G2=3,OR(H2="High",H2="Medium")),"Y","")

 

[alansidman]

=IF(AND(OR(B1="a",B1="b",B1="c"),E1<DATEVALUE("1/4/21"),G1=3,OR(H1="HIGH",H1="MEDIUM")),"Y","N")

Sum positive and negative nos separately.xlsx
	B	C	D	E	F	G	H	I	J
1	a			1/2/2021		3	HIGH		Y
2	b			4/25/2021		2	MEDIUM		N
3	c			1/2/2021		3	MEDIUM		Y
Sheet2

Cell Formulas
Range	Formula
J1:J3	J1	=IF(AND(OR(B1="a",B1="b",B1="c"),E1<DATEVALUE("1/4/21"),G1=3,OR(H1="HIGH",H1="MEDIUM")),"Y","N")

 

[theonlyhamish]

Brillian!, thanks Gurus!