=IF(OR(Q118={"$","€"}),VLOOKUP(E118,[RefHidden_120112.xlsm]Ref!$BY$5:$CB$60,MATCH(Q118,[RefHidden_120112.xlsm]Ref!$BY$3:$CB$3,0)),"1.00")

I want to adapt this formula for it to return "--" IF Q118="". I am not sure of the syntax to add the extra IF. Thanks.

Dan