• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search for values between 2 not related tabes

Maha2303

New Member
Hello,

I'm having an issue looking for values from column in table 1 in a column in table 2. Tables are not related and a relationship cannot be created.
First I have created a column under table 1 called purchase order that retreive first last 9 caracters
Purchase Order = LEFT('Transport Orders'[PurchaseOrderNumbers],9)

Now, I need to search of the values found in column "purchase order" in the second tabl called "transport demand data[PurchaseOrderNumbers]"

I have tried lookupvalue, related but didn't work.

Please I need an urgent help!!
Thank you in advance!.
 
Back
Top