If value(another table) with Lookup

[ofeliajesus]

Hello

I have three table 

ProdCategories

CatID	Name	Status
AV1	A	-
AV2	B	-
AV3	C	X
AV4	D	X
AV5	E	-

ProdInventory

ItemID	Item	CatID
1	AB	AV1
2	AC	AV1
3	AD	AV2
4	AE	AV4
5	AF	AV3

ProdRelease

ItemID	Item	CatID
2	AC	AV1
4	AE	AV4
6	DC	AV5
7	TU	AV5

ProdInventory and ProdRelease are not related, but both are connected to the ProdCategories by CatID

I want to add a column in the table ProdInventory that checks IF the ProdCategories Status = "X" If

Yes Does a Vlookup In table ProdRelease By ItemID IF find it shows"No" if not shows"Yes" 

No shows "No"

Formula from Spreadsheet

=IF(G4="X", IF(ISERROR(VLOOKUP(K4, ProductionInventoryRelease!H: H,1, FALSE)), "No", "YES"), "No")

The result is:

ItemID	Item	CatID	NewColumn
1	AB	AV1	No
2	AC	AV1	No
3	AD	AV2	No
4	AE	AV4	No
5	AF	AV3	Yes

Thanks in Advance

[Nathaniel_C · Accepted solution]

Hi @ofeliajesus ,
Please try this:

x = IF(RELATED(ProdCategories[Status])="X", If(ISBLANK(LOOKUPVALUE(ProdRelease[Item],ProdRelease[Item],ProdInventory[Item])),"Yes","No"),"No")

You said that you wanted to add a column to your table. Here is what it will look like after creating a calculated column.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel