-=PCTechTalk=- Excel Question (Kinda Long)
- From: "Eddie Carroll" <kd4bas@xxxxxxxxxxxxx>
- To: "PC Tech Talk" <pctechtalk@xxxxxxxxxxxxx>
- Date: Thu, 4 Sep 2003 12:01:50 -0500
First of all, if this is not the correct group to ask this question, I
apologize.
I am using Excel 2000 and am having issue trying to pull this particular
information.
With this work sheet I am trying to accomplish several problems. First of all,
there are 9 values in cell D19, which displays in text the following
information, please ignore what is in between the brackets { & }, that was
added to let me keep up with what the actual values are. All the following
information is in dropdown boxes where the value of the cells is listed in the
formula.
ROUTER TYPES
=IF(D19=2,"Efficient 5851") &IF(D19=3,"Efficient 5351") &IF(D19=4,"Efficient
5260") &IF(D19=5, "Efficient 5871") &IF(D19=6, "Zyxel 643") &IF(D19=7, "Zyxel
645") &IF(D19=8, "Flowpoint 2200") &IF(D19=9,"Netopia 7200") &IF(D19=10,
"Netopia 7220","")
Each of the "Router Types" will then need to pull the needed values from the
following cells, located in 5 different locations, on the spreadsheet. Each of
these cells has a value between 2 & 8 for the light status.
if(D19)=2 {5851} then pull values from cells (H23), (I23), (J23), (K23) Each
cell has a value between 2 & 8 {Light Status}
if(D19)=3 {5351} then pull values from cells (H23), (I23), (J23), (K23) Each
cell has a value between 2 & 8 {Light Status}
if(D19)=4 {5260} then pull values from cells (B23), (C23), (E23), (F23) Each
cell has a value between 2 & 8 {Light Status}
if(D19)=5 {5871} then pull values from cells (H23), (I23), (J23), (K23) Each
cell has a value between 2 & 8 {Light Status}
if(D19)=6 {643} then pull values from cells (H27), (I27), (J27), (L27), (N27)
Each cell has a value between 2 & 8 {Light Status}
if(D19)=7 {645} then pull values from cells (H27), (I27), (J27), (L27), (N27)
Each cell has a value between 2 & 8 {Light Status}
if(D19)=8 {2200} then pull values from cells (A27), (C27), (D27), (E27) Each
cell has a value between 2 & 8 {Light Status}
if(D19)=9 {7200} then pull values from cells (A31), (C31), (D31), (G31), (H31)
Each cell has a value between 2 & 8 {Light Status}
if(D19)=10 {7220} then pull values from cells (A31), (C31), (D31), (G31), (H31)
Each cell has a value between 2 & 8 {Light Status}
I also want to set up some type of warning popup that associates with D19, that
if the cell value is NOT 1 (reset position) or between 2 & 10, it displays the
following warning
if(D19)=1 ERROR -> MUST ENTER ROUTER TYPE AND LIGHT STATUS<-
*********************************************************************************
LIGHT STATUS
=IF(D19=2,"OFF","") &IF(D19=3,"Red","") &IF(D19=4,"Flashing Red","") &IF(D19=5,
"Green","") &IF(D19=6, "Flashing Green","") &IF(D19=7, "Amber","") &IF(D19=8,
"Flashing Amber","")
Please feel free to contact me direct or to the list if you can help me, or
need further help
Eddie C.
Kd4bas@xxxxxxxxxxxxxxxxxxx
Remove NO Spam to contact me
Eddie Carroll
KD4BAS / KIN9ET
First Responder
Level I Fire Service Instructor
Morganfield, KY Fire & Rescue
Incident Page Network KTY-005
National Incident Notification Network DKY-3
Storm Chasers of America # 74
ICQ# 149667298
http://www.geocities.com/nutcase1967
In memory of Dale Earnhardt,
"The Legend Lives on"
To unsub or change your email settings:
//www.freelists.org/webpage/pctechtalk
To access our Archives:
http://groups.yahoo.com/group/PCTechTalk/messages/
//www.freelists.org/archives/pctechtalk/
For more info:
//www.freelists.org/cgi-bin/list?list_id=pctechtalk
Other related posts:
- » -=PCTechTalk=- Excel Question (Kinda Long)
