I want to retrieve the value in cell on active sheet if it matches the corresponding email column and has the keyword search. This formula is showing the error #VALUE!:
IF(INDEX('DATA 1'!C:C;MATCH(OUTPUT!B13;'DATA 1'!A:A;0)="search");INDEX('DATA 1'!C:C;MATCH(B13;'DATA 1'!A:A;0));"Not available")
Aucun commentaire:
Enregistrer un commentaire