Forum Discussion
Post ProdigyIF with LOOKUPVALUE - simple check
Hi,
I have 2 tables, which don't have any relationship.
Now, I want to find, if my values can be found in different table, sort of a simple check.
How to modify my column without getting into needless details?
Hi pawelj795 ,
Based on your description, I did a test. You can create a similar column as follows.
Column = IF('Sales'[Director]in VALUES(Sales_Target[Director]),"I Level BOM","II Level BOM")Here is my test result.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi pawelj795 ,
Based on your description, I did a test. You can create a similar column as follows.
Column = IF('Sales'[Director]in VALUES(Sales_Target[Director]),"I Level BOM","II Level BOM")Here is my test result.
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
pawelj795 , In think this because more than one value. Take max for result
Or refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
pawelj795amitchandak
Yes, I'm aware that it find more than one value.
But is it possible to do like vlookup in excel?
In this case it would return first possible value.
In my case, I want only to check if it find some value or anything.
- amitchandak
pawelj795 , try firstnonblank(bom_line[oriduct_temp1_id],"NA") as result and check
