remove #n/a from the columnI've used a function

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I have used a function and dont want to get #n/a but replace with a blank
after using
=INDEX('K1'!A:B, MATCH(HAM!C62, 'K1'!A:A,0),2)
 
You can do it like this:

=IF(ISNA(MATCH(HAM!C62,'K1'!A:A,0)),"",INDEX('K1'!A:B,MATCH(HAM!
C62,'K1'!A:A,0),2))

Hope this helps.

Pete
 
Back
Top