Need an assistance for formula

[hussein_elsayed]

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 · Accepted 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.

[#3]

Thank you very much