Need help with a formula

[RLJ]

I need a formula for the below example. I have tried using an =IF(VLOOKUP... that comes up with #N/A when something is not on the second table.

I have 2 tables of information. The one in columns A:C and the second in columns E:G. The table in E:G will not always have the same items as the table from A:C. I need a formula for column C that will reference the ID from Columns A & E and if it is on the table E:G to look at Column G to see if there is a blank or not. If there is a blank then the value in column C needs to be Yes and if column G is not blank then the value in column C needs to be No.

In addition, if the corresponding value from Column A is NOT in Column E, then I want the Value in Column C to also be NO.

Book1
	A	B	C	D	E	F	G
1	Product ID	Description	Outstanding		Product ID	Date Assigned	Date Completed
2	1234	1 Desc	No		1237	2/29/2024	3/8/2024
3	1235	2 Desc	No		1238	2/29/2024
4	1236	3 Desc	No		1239	3/1/2024	3/8/2024
5	1237	4 Desc	No		1240	3/3/2024
6	1238	5 Desc	Yes
7	1239	6 Desc	No
8	1240	7 Desc	Yes
9	1241	8 Desc	No
10	1242	9 Desc	No
11	1243	10 Desc	No
12	1244	11 Desc	No
13	1245	12 Desc	No
14	1246	13 Desc	No
Sheet1

 

[Fluff]

How about

=IF(XLOOKUP(A2,$E$2:$E$5,$G$2:$G$5,"")=0,"Yes","No")

 

[dreid1011]

Give this a try:

Book1
	A	B	C	D	E	F	G
1	Product ID	Description	Outstanding		Product ID	Date Assigned	Date Completed
2	1234	1 Desc	No		1237	2/29/2024	3/8/2024
3	1235	2 Desc	No		1238	2/29/2024
4	1236	3 Desc	No		1239	3/1/2024	3/8/2024
5	1237	4 Desc	No		1240	3/3/2024
6	1238	5 Desc	Yes
7	1239	6 Desc	No
8	1240	7 Desc	Yes
9	1241	8 Desc	No
10	1242	9 Desc	No
11	1243	10 Desc	No
12	1244	11 Desc	No
13	1245	12 Desc	No
14	1246	13 Desc	No
Sheet3

Cell Formulas
Range	Formula
C2:C14	C2	=IFERROR(IF(XLOOKUP(A2,$E$2:$E$5,$G$2:$G$5)="","Yes","No"),"No")

 

[RLJ]

How about

=IF(XLOOKUP(A2,$E$2:$E$5,$G$2:$G$5,"")=0,"Yes","No")

Looks like this works. I will test out on my real workbook.

 

[Fluff]

Ok