IF function with function result as condition

andri witana

hi all;

=IF([Link SO]@row = "#NO MATCH"; "Tersedia"; "Terjual")

so i want to create this formula, if the condition cell contain "#NO MATCH" which is a result of INDEX function.

it always result in "#NO MATCH"

any input?

thx

update!..... edit

sorry all. plz ignore. i have found the solution

for those who found same problem, #NO MATCH is an error result

so combine any function with IFERROR function if you need to use the cell as reference of other cell formula

andri witana

sorry all. plz ignore. i have found the solution

for those who found same problem, #NO MATCH is an error result

so combine any function with IFERROR function if you need to use the cell as reference of other cell formula

andri witana

sorry all. plz ignore. i have found the solution

for those who found same problem, #NO MATCH is an error result

so combine any function with IFERROR function if you need to use the cell as reference of other cell formula

Genevieve P.

Hi @andri witana

I'm glad you found a solution! The IFERROR function is a great idea for this. Thanks for posting what you found.

Cheers,

Genevieve