Forum Discussion
Solved
Need an assistance for formula
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)...
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.
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