Help with a #UNPARSEABLE error

Alicia L

I want to reference the values in a column from another sheet (2025 IOE Procedure Assessments Equipment). And if any of them match any cell from the Equipment column from the sheet I'm working in then, I want the Audit on Equipment Completed column to return a "Completed" value.

This is my formula. What is wrong with it?

=INDEX({2025 IOE Procedure Assessments Equipment}, MATCH[Equipment]@ROW, ([AUDIT ON EQUIPMENT COMPLETED], "Completed", ""))

Kelly Moore

@Alicia L

Try this

=IF(COUNTIFS({2025 IOE Procedure Assessments Equipment}, Equipment@row)>0,"Completed")

This formula goes in your [AUDIT ON EQUIPMENT COMPLETED] column. It will count matches of the Equipment@row in your {2025 IOE Procedure Assessments Equipment} column. (This range {2025 IOE Procedure Assessments Equipment} does refer to a single column, correct? If not, it should.) If the count is greater than zero it means a match was found, and the formula will then return "Completed" value. If the Count = zero (ie no match) then the cell will remain blank.

I noted when you wrote your formula you catpitalized @ROW. This must be written in lower case - you will receive error messages if upper case is used.

Will this work for you?
Kelly

Kelly Moore

@Alicia L

Try this

=IF(COUNTIFS({2025 IOE Procedure Assessments Equipment}, Equipment@row)>0,"Completed")

This formula goes in your [AUDIT ON EQUIPMENT COMPLETED] column. It will count matches of the Equipment@row in your {2025 IOE Procedure Assessments Equipment} column. (This range {2025 IOE Procedure Assessments Equipment} does refer to a single column, correct? If not, it should.) If the count is greater than zero it means a match was found, and the formula will then return "Completed" value. If the Count = zero (ie no match) then the cell will remain blank.

I noted when you wrote your formula you catpitalized @ROW. This must be written in lower case - you will receive error messages if upper case is used.

Will this work for you?
Kelly

Alicia L

Thank you! That worked.