IF from a range of cells
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
|