Forum Discussion
butterscotch
Helper II
Helper IILOOKUPVALUE
Hello everyone! im facing an issue with LOOKUPVALUE , where it only return the first matching value but i have multiple data (project) this is the 1st table: this is the 2nd table: ...
in merge queries, you can merge on multiple columns.
just click CTRL btton while selecting the columns you want to merge on,
hope this helps.
butterscotchHelper II
Helper IIthis is the result when i merge both tables
as you can see, the table only retrieve the 1st value from norm , if and only if the merging action allow me to select 2 columns that can be used to match these values
Daniel29195
Community Champion
Community Championin merge queries, you can merge on multiple columns.
just click CTRL btton while selecting the columns you want to merge on,
hope this helps.
- butterscotch
Daniel29195 , omg it works ! thank you so much !