Jul 28 2022 08:11 PM
Hi All,
I am trying to map transaction count to pricing tier based on reference table which has pricing tier for every range of transaction counts...Please find attached the sheet...Can you please help me here..
Thanks,
Arun
Jul 28 2022 08:32 PM - edited Jul 28 2022 08:34 PM
You need XLOOKUP() function. Try-
=XLOOKUP(C14,$K$2:$K$7,$J$2:$J$7,"",-1)
If your version of excel support LAMBDA() function then try BYROW() function for array approach.
=BYROW(C14:C18,LAMBDA(x,XLOOKUP(x,K2:K7,J2:J7,"",-1)))