Forum Discussion

Mueez's avatar
Mueez
Frequent Visitor
5 years ago
Solved

Help Needed with Lookup Function

Hi,   I have a very simple code in calculated cloumns where I am using lookup value to get required information from another table.   =LOOKUPVALUE('Knock off details for AP'[Document No.],'Knoc...
Need Help
Mueez's avatar
Mueez
Frequent Visitor
5 years ago

@Fowmy Thanks for replying

I am pretty sure there are no duplicates because when I change code as following I stop getting error.

= LOOKUPVALUE ('Cancellation details for AP' [Document No.], 'Knock off details for AP' [Vendor Ledger Entry No.], <hard code entry number>, 'Knock off details for AP' [ Entry Type], "Application" )

But this is obvioulsy not what I want. The formula needs to iterate through each line in of the table.

Best Regards,

Mueez

Mueez's avatar
Mueez
Frequent Visitor
5 years ago

Fowmy 

 

Also, even if say there are duplicates. Isn't there way we can handle those?

 

Regards,

Mueez

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Mueez 

    A column cannot contain two Document Numbers. That is not the right way. But, you can still do it using CONCATNATEX and FILTER functions

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn