Hide #N/As with Cell Indexing/Matching
Rob,
Maybe this
=IF(ISNA(INDEX($K$6:$K$158,MATCH($E6,$K$6:$K$158,0 ),1)),"No","Yes")
or even this
=IF(ISNA(INDEX($K$6:$K$158,MATCH($E6,$K$6:$K$158,0 ),1)),"No",INDEX($K$6:$K$158,MATCH($E6,$K$6:$K$158 ,0),1))
Mike
"Rob" wrote:
Iwas wondering if anyone knows how I can get the "#N/A" to stop being
displayed for line items that are not found? The first formula is the one I
originally used and the second formula was my attempt at having it display a
"No" instead of "#N/A". The second formula fails... It shows the "Yes" Just
Fine but when it comes to the no part is flops and shows #N/A.
INDEX($K$6:$K$158,MATCH($E6,$K$6:$K$158,0),1)
=IF(INDEX($K$6:$K$158,MATCH($E6,$K$6:$K$158,0),1)= "#N/A","No","Yes")
Thanks in Advance,
Rob
|