Mapping the transaction count to pricing tier based on reference table

Contributor

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

1 Reply

@Arun Chandramouli 

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)))