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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hiding an error value, using INDEX/MATCH 3
Removing #N/A 4
Correct #N/A Value 6
Adding the resulting intersection to an If statement. 1
How can i change the #N/A error for a 0 value 2
Vlookups to return a N/A value 3
How to convert #N/A to 0 using Match? 8
Referencing date column A & time column B to get info from column 1

Top