Replacing #N/A

R

RFJ

I've got the formula below working. However, if data is incomplete in the
modeller worksheet, the #N/A error (rightly) comes up.

I want to replace #N/A with the message "Missing Data" but I can't seem to
get the syntax correct.

Can SKS help me out.

TIA

Rob


=INDEX('Modeller'!$C$5:$C$75,MATCH("~*",'Modeller'!Q$5:Q$75,0))
 
R

RagDyeR

Try this:

=IF(ISNA(MATCH("~*",Modeller!Q$5:Q$75,0)),"Missing
Data",INDEX(Modeller!$C$5:$C$75,MATCH("~*",Modeller!Q$5:Q$75,0)))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I've got the formula below working. However, if data is incomplete in the
modeller worksheet, the #N/A error (rightly) comes up.

I want to replace #N/A with the message "Missing Data" but I can't seem to
get the syntax correct.

Can SKS help me out.

TIA

Rob


=INDEX('Modeller'!$C$5:$C$75,MATCH("~*",'Modeller'!Q$5:Q$75,0))
 
Top