Forum Discussion
Match and If ?
I am trying to put the match and if functions into a formula (if they are the correct ones to use) I have two sheets, "Front" and Expenses" In Column E on the Front sheet i want to look in Column...
In E2 on the Front sheet:
=IFERROR(VLOOKUP(C2,Expenses!$A$3:$B$6,2,FALSE),"")
If you have Microsoft 365 or Office 2021), you can also use
=XLOOKUP(C2,Expenses!$A$3:A$6,Expenses!$B$3:$B$6,"")
Fill down.