Forum Discussion
LOOKUPVALUE with multiple results
Hi,
Yes, that should be possible. Paste the base data here so that i can copy that in Excel.
Hi,
Example data is below, you will need to merge tables 1 and 2 first.
Table 1
Customer/Plan (To-Be)
8300002592_AF
8300002602_AF
8300002222_AF
Table 2
Customer/Plan (As-Is) Contract ID
8300002592_AF T-0019141
8300002592_AF T-0018171
8300002592_AF T-0018172
8300002592_AF T-0018122
8300002602_AF T-0019149
8300002602_AF T-0018177
8300002602_AF T-0018194
Thanks,
David.
Thank you, that was exactly what I was looking for! :)
You are welcome.
Hello Ashish,
read your post and was trying to implement as described but I received some error messages
I want to use your code to expand a table 1 of various columns (picture below shows only two columns for simplicity) with another table 2 through the common column "sector" . From table 2, I want to carry 3 columns (application, Units, Price) into the new table "desired result". I tried the following code in a new table, but was not succesfull:
Source = Table.NestedJoin(#"table1", {"Sector"}, #"table2",{"Sector"},#"result",JoinKind.LeftOuter)
Hope you can help. Thanks in advance!
Share some data to work with and show the expected result clearly.
