ExcelBanter - error message handling #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - error message handling #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/179575-error-message-handling-n.html)

Mifty

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

Mike H

error message handling #N/A

Try this

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

Mike

"Mifty" wrote:

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

Mifty

error message handling #N/A

Mike,

Forgot to say 'Yes works beautifully'

Many thanks
--
Mifty

"Mike H" wrote:

Try this

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

Mike

"Mifty" wrote:

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

All times are GMT +1. The time now is 02:53 PM.