Try this:

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

--

HTH,

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

"RFJ" wrote in message
...
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))