Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |