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).
waiting your kind assist.
Thanks in advance
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.
2 Replies
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
