Thread: error message handling #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mifty Mifty is offline
external usenet poster
  
Posts: 99
Default error message handling #N/A
Hi,

Could any kind soul out there tell me how I would add ISERROR to the
following to stop #N/A?

'=INDEX(Sheet1!$A$7:$A$1152,MATCH($C79,Sheet1!$C$7 :$C$1152,0))

Cheers
--
Mifty
Reply With QuoteReply With Quote