I've read the previous postings regarding the use of more than 7 if then
statements, and tried the following:
CELL D2 =IF(OR(B4=4,B4=5,B4=6,B4=14,B4=16),"Mike
Pelosi",IF(OR(B4=1,B4=2,B4=3,B4=13,B4=24),"Nick
Re",IF(OR(B4=7,B4=8,B4=22,B4=35),"Nicole Hughes",IF(OR(B4=20,B4=25,B4=9),"Kim
O'Connor", "D3"))))
CELL D3 =IF(OR(B4=19,B4=21,B4=26,B4=15,B4=18),"Justin
Eldredge",IF(OR(B4=23,B4=30,B4=34,B4=36),"Janet Ward",IF(OR(B4=11,B4=12),"Jen
Ferrarraccio")))
CELL D4 =IF(B4=D2),D2,D3
I am attempting to make the formula for column D (fromD4 down) assign a
"Person" to the cell based on the number located in column B. However, this
doesn't seem to be working. I would greatly appreciate some help!
Thanks,
Mike