I'm using concatenated If statements, in this format: =IF(B5="A",I32,"")&IF(B5="B",I39,"")&IF(B5="C",I45,""). However, there's a limit of 30 or so, and I'd like to use more than that, over 100. Is there any way to get around this, maybe by using another formula? Thanks.