If statement referencing column to find match and reference second column

[justin_n84]

I am looking for the right input for the bleow. I am struggling to get my head round this one, however I know it will be simple for somebody out there.

Please see attached image. All will make sense.

Sheet 1 column D, If Column A is listed in Column B of Sheet 2, reference column E (of the line it is listed) for input “V”. If this is true “Accept”, if not “reject”

 

[awoohaw]

please let us know what version of excel you use, and update your profile to display?
if you have excel 365:

try: (I may have typos)

=IFERROR(xlookup(A2,Sheet2!B:B,Sheet2!E:E)="V","Accept","Reject"),"Not Found")

 

[awoohaw]

here are two options:

mr excel questions 12.xlsm
	A	B	C	D	E	F
1	Manifold	XlOOKUP	INDEXMATCH		Weld	Accept
2	HD	No Match	No Match		AA
3	LY	No Match	No Match		EC	V
4	EC	Accept	Accept		BB
5	BS	Reject	Reject		BS	Y
6	SR	Reject	Reject		CC
7	QM	No Match	No Match		DD
8	KU	No Match	No Match		SR	X
9	DG	No Match	No Match		EE
10	CM	No Match	No Match		QQ
11	AE	No Match	No Match		TT
Sheet29

Cell Formulas
Range	Formula
B2:B11	B2	=IFERROR(IF(XLOOKUP($A2,$E$2:$E$11,$F$2:$F$11)="V","Accept","Reject"),"No Match")
C2:C11	C2	=IFERROR(IF(INDEX($F$2:$F$11,MATCH($A2,$E$2:$E$11,0))="V","Accept","Reject"),"No Match")

 

[justin_n84]

please let us know what version of excel you use, and update your profile to display?
if you have excel 365:

try: (I may have typos)

=IFERROR(xlookup(A2,Sheet2!B:B,Sheet2!E:E)="V","Accept","Reject"),"Not Found")

Hi, thank you soo much for putting this together. I am using Excel 365.

I have entered your formular, however, Excel states too many arguments? Sorry I am not so clued up around these types of formulas.....

 

[justin_n84]

Hi tahnk you for the calculations. This seams to have worked. Much appreciated.

 

[awoohaw]

Happy to help. Best wishes. If you thing one of the posts has provided you with a solution please mark that particular post as the answer.