Try using an array formula (committed with Ctrl-Shift-Enter) instead:

=IF(OR(Sheet2!$A$2:$A$7=G19),$E$19,"0")



"Duncan Sibbald" <duncansibbald"no spam" wrote:

I am having real trouble with this !

Basically, I have a range of cells from A2 to A13 on Worksheet 2. These are
in a named range and form part of a drop down list in Worksheet 1. What I
want to happen is that when I select a value from any of the ranges from A2
to A7 from cell G7 in Worksheet 1 (in the drop down menu), it will paste the
value from E19 otherwise return 0.

I have got this so far:
=OR(IF(Sheet2!$A$2=G19,$E$19,"0"),IF(Sheet2!$A$3=G 19,$E$19,"0")), so as you
see I am not really getting anywhere !

Any help would be gratefully received.

Best regards,

Duncan