Forum Discussion
Returning Multiple lines with the same reference (XLOOKUP)? For a quotation look up document
Hi All, I have been struggling with this for some time and cant quite seem to get over this hump. I am trying to build a quotation spreadsheet to rapidly increase what is done manually by c...
- Hi Detlef, thanks for the comment!
I'm afraid I'm pretty basic in my Excel use. No formal training, just self taught from forums and YouTube.
Can you simplify for the uninitiated please? 😄I uploaded the modified file.
I am not very good in giving a detailed description.
I suggust you look for tutorials. Keywords are "left outer join", "remove columns", "load into worksheet table".
https://www.google.com/search?q=how+to+start+with+power+query
