How do change the return Value from a =IFERROR(INDEX(COLLECT fomula

Radial_Rob

Hello,

I have a formula that does work the way it should,

=IFERROR(INDEX(COLLECT({STATUS}, {USERID}, [USER ID]@row, {Title}, "ENVISION"), 1), "Not Attended"). It does return what is listed in the status column on another sheet. If there is nothing listed then it returns "Not Attended". Perfect!

Is there a way to change the return value if something is listed? So if there is a value listed, can it be forced to say "Attended" instead the true value?

JR90

Hi,

Are you just wanting to have the cell say "Not Attended" if the status is blank and "Attended" if there is a value listed?

Radial_Rob

Hello, there are several values listed on the source sheet, Completed, Waitlist, Started and Dropped. If is says Completed, we need it to say "Attended". If it says anything else, "Not Attended".

JR90

Anyway you could share a screenshot?

Radial_Rob

A is the master sheet. B is a sub sheet. The formula looks for a persons ID and what is in the title column. For example, if the formula on B finds my id and a status for We Envision it will return what is in the Status column on Sheet B. If nothing is found it will return "Not Attended"(currently says not registered). We would like a formula to translate Started, Not Attended and Registered to Not Attended and Completed to Attended.