I want to add a IF statement to a simple vlookup that checks something additional.

MJ215

Does anyone have any suggestions on adding a IF to this current formula that would say IF "Approved" than "Excluded" else this would pull from another sheet or be "Not Started".

I made the automation looked for status changes to "Approved" for the column to change to "Excluded" but that wasn't working.

Paul Newcome

You would want something like this...

=IF([Exclusion Status]@row = "Approved", "Excluded", IFERROR(VLOOKUP(.....................), "Not Started"))