Forum

How to do "Exact ma...
 
Notifications
Clear all

How to do "Exact match. If none found, return the next larger item" in power query.

2 Posts
2 Users
0 Reactions
216 Views
(@ramram)
Posts: 1
New Member
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
Riny van Eekelen
(@riny)
Posts: 1185
Member Moderator
 

Better late than never. Please see if the attached file accomplishes what you need.

 
Posted : 20/11/2023 6:21 am
Share: