Replacing #N/A

  • Thread starter Thread starter RFJ
  • Start date Start date
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))
 
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))
 
You must log in or register to reply here.

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

Scrabble Value calculation for Welsh words 0
IF #N/A 4
Checking values in 2 columns 4
Vlookups to return a N/A value 3
Correct #N/A Value 6
Don't Display #N/A 1
match formula 2
Vlookup returns n/a for all lines - what am I missing? 3

Back
Top