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))