Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
216
Views
Topic starter
Hi All,
I have data, having "Employee ID", "Sum Insured" and another Colum as "Deductible". I want to lookup Deductible which are equal to or next larger item.
I t is possible in excel with use of XLOOKUP, But I Wanto to do it in Power Query.
Please assist me in this.
Posted : 14/11/2023 8:31 am
Better late than never. Please see if the attached file accomplishes what you need.
Posted : 20/11/2023 6:21 am