Nested IF with multiple functions included returning unparseable

mifala.chris

I have a complex sheet along with a Metadata sheet and wanting to add certain results according to the following formula. =IF(UPN@row <> "", (IF(CONTAINS("VFD", [Equipment ID]@row), "1823", (INDEX({Cardinal Metadata - UPN & UPI List 'WBS'}, (MATCH({Cardinal Metadata - UPN & UPI List 'UPN'},@row, 0), 0))), "") No matter where I think the error is its kicking my brain this morning. The desired outcome is either an empty cell 1823 if the id contains VFD or WBS number matching its UPN per the Metadata sheet.

In advance thanks for any help that can move me forward

Paul Newcome

It looks like there are some extra parenthesis throughout, the column to match on wasn't specified, and there are a few syntax issues. Give this a try:

=IF(UPN@row <> "", IF(CONTAINS("VFD", [Equipment ID]@row), "1823", INDEX({Cardinal Metadata - UPN & UPI List 'WBS'}, MATCH(UPN@row, {Cardinal Metadata - UPN & UPI List 'UPN'}, 0))), "")

Paul Newcome

It looks like there are some extra parenthesis throughout, the column to match on wasn't specified, and there are a few syntax issues. Give this a try:

=IF(UPN@row <> "", IF(CONTAINS("VFD", [Equipment ID]@row), "1823", INDEX({Cardinal Metadata - UPN & UPI List 'WBS'}, MATCH(UPN@row, {Cardinal Metadata - UPN & UPI List 'UPN'}, 0))), "")

mifala.chris

Thankyou kind sir I appreciate the assistance with this, Chris

mifala.chris

Paul Newcome

Happy to help. 👍️