SOLVED

Need an assistance for formula

Contributor

Dears,

is that any way to make the lookup interest in the attached sheet to be easier than the exist formula (highlighted in yellow) specially when i add a new rate in the seconed sheet (rate sheet).

 

waiting your kind assist.

 

Thanks in advance

2 Replies
best response confirmed by hussein_elsayed (Contributor)
Solution

@hussein_elsayed 

In J5:

If you have Microsoft 365 or Office 2021:

=IF($B$53="ETAPA",2%,XLOOKUP(F5,Rates!$A$3:$A$50,Rates!$C$3:$C$50,"",-1))

If you have an older version:

=IF($B$53="ETAPA",2%,IFERROR(VLOOKUP(F5,Rates!$A$3:$C$50,3),""))

Fill down.

Thank you very much