Abhay Gadiya
New Member
- Joined
- Jul 1, 2013
- Messages
- 24
Hi,
I want to find a solution using Power Query compared to current solution I have by using Array Formulas.
Please have a look at this data
https://www.dropbox.com/s/ma66bxx5wiarstp/Service Tax Lookup.xlsx?dl=0
Under "Raw Data" tab I have column named "Text for Keyword" and subsequent columns use lookup formulas to fetch details from second tab named - "Rate List".
I want to find "Keyword" from Rate list tab in "Text from Keyword" column under Raw Data tab and then fetch "Description" column from Rate List tab to Raw Data tab.
I think it would be easier if you look at the formulas I have entered in Raw Data tab for clarity.
I want this to be done using Power Query rather than putting formulas every time I have to perform this.
Please help.
I want to find a solution using Power Query compared to current solution I have by using Array Formulas.
Please have a look at this data
https://www.dropbox.com/s/ma66bxx5wiarstp/Service Tax Lookup.xlsx?dl=0
Under "Raw Data" tab I have column named "Text for Keyword" and subsequent columns use lookup formulas to fetch details from second tab named - "Rate List".
I want to find "Keyword" from Rate list tab in "Text from Keyword" column under Raw Data tab and then fetch "Description" column from Rate List tab to Raw Data tab.
I think it would be easier if you look at the formulas I have entered in Raw Data tab for clarity.
I want this to be done using Power Query rather than putting formulas every time I have to perform this.
Please help.