Forum Discussion
If value(another table) with Lookup
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
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
1 Reply
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