Rate fetching from rate card with more than 1 condition

New Contributor
Transaction Data       
Sheet NameTxn ValueRate  Rate Card Table 
115000?  SchemeLower ValeUpper ValueRate 
213000?  10129992 
320000?  113000199994 
     120000 5 
     212000 3 
     325000 6 


given above is short data and actual data have huge no of line items require formula for sort this out

2 Replies
best response confirmed by Hans Vogelaar (MVP)



Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.


It works. Thank you very much @Quadruple_Pawn