glabossi
asked on
NEED HELP FAST! Need to add vlookup formula to IF statement
Please see attached. I have two tabs (DELETE CODE and UPDATE EXPENSE).
In column "D" in UPDATE EXPENSE, I have a formula looking in DELETE CODE tab which says "If column D in DELETE CODE tab = "Delete", then "Ignore" or else "Update Expense".
I need to add a vlookup to the IF statement in UPDATE EXPENSE tab to match Column C in (Program Code) so it provides the value for the correct program.
Please help!
Thanks!
sample-code-aug-24.xlsx
In column "D" in UPDATE EXPENSE, I have a formula looking in DELETE CODE tab which says "If column D in DELETE CODE tab = "Delete", then "Ignore" or else "Update Expense".
I need to add a vlookup to the IF statement in UPDATE EXPENSE tab to match Column C in (Program Code) so it provides the value for the correct program.
Please help!
Thanks!
sample-code-aug-24.xlsx
ASKER
This is perfect! How can I add a 4th condition if its not applicable?
If a program code is not in the the DELETE CODE sheet at all I would need "Update Expense" value to be populated in UPDATE EXPENSE sheet automatically?
If a program code is not in the the DELETE CODE sheet at all I would need "Update Expense" value to be populated in UPDATE EXPENSE sheet automatically?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
PERFECT!!!! THANK YOU SO MUCH!!!!
=IF(VLOOKUP(C2,'DELETE CODES'!$C$1:$D$5,2,0)="Del
copy down.
Thomas