Hello,

My name is Ming and I'm new to the forum. Thank you for having a resource such as this so I can ask questions. I've found a way to next up to 26 variables within one cell, like this...

=IF(OR((DG6=1),(DG6=2),(DG6=3),(DG6=4),(DG6=5),(DG6=6)),IF((DG6=1),BC6,IF((DG6=2),BD6,IF((DG6=3),BE6,IF((DG6=4),BF6,IF((DG6=5),BG6,BH6))))),IF(OR((DG6=7),(DG6=8),(DG6=9),(DG6=10),(DG6=11),(DG6=12)),IF((DG6=7),BI6,IF((DG6=8),BJ6,IF((DG6=9),BK6,IF((DG6=10),BL6,IF((DG6=11),BM6,BN6))))),IF(OR((DG6=13),(DG6=14),(DG6=15),(DG6=16),(DG6=17),(DG6=18)),IF((DG6=13),BO6,IF((DG6=14),BP6,IF((DG6=15),BQ6,IF((DG6=16),BR6,IF((DG6=17),BS6,BT6))))),IF(OR((DG6=19),(DG6=20),(DG6=21),(DG6=22),(DG6=23)),IF((DG6=19),BU6,IF((DG6=20),BV6,IF((DG6=21),BW6,IF((DG6=22),BX6,BY6)))),IF((DG6=24),BZ6,IF((DG6=25),CA6,IF((DG6=26),CB6,"")))))))

I wanted to find out if it's possible to go up to 52. I'd like to extract information based on which week in the year we're in (52 weeks in one year). So do you think this is possible? If not, I'll have to find another solution. Thank you for your expertise and help. Ming