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 |
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 |
Duke,
Worked perfectly ! Thanks so much, Duncan "Duke Carey" wrote in message ... 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 |
All times are GMT +1. The time now is 08:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com