error message handling #N/A

M

Mifty

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
 
M

Mike H

Try this

=IF(ISNA(INDEX(Sheet1!$A$7:$A$1152,MATCH($C79,Sheet1!$C$7:$C$1152,0))),"",INDEX(Sheet1!$A$7:$A$1152,MATCH($C1,Sheet1!$C$7:$C$1152,0)))


Mike
 
Top