CODEWITHSUNDEEP
excelexcel-formula
kriti986
kriti986

Reputation: 1

Excel- How to return a Nested ISBLANK IF statement that has different variants for each cell?

So, say A1 = Rodgers B1 = Mahomes C1 = D1= E1= Jackson

How can I do a combined nested if statement for each variant, if they are blank they stay blank.

So, my variants are If A1 contains a value then Packers = Rodgers, if B1 contains a value then Chiefs = Mahomes, If E1 Contains a value then Ravens = Jackson.

The final output would not have C1 and D1 as they return blank cells. I would then drag that down to 500 cells below that.

I can do a single one = If(ISBLANK(A1)," ","Packers:"&A1)) but I can't do a combined one, I have tried If(ISBLANK(A1)," ","Packers:"&A1, If(ISBLANK(B1)," ","Chiefs:"&B1))) but this is not working

Upvotes: 0

Views: 37

Answers (1)

jblood94
jblood94

Reputation: 16981

Put the team names in a CHOOSE statement:

=IF(LEN(A1)=0,"",CONCATENATE(CHOOSE(COLUMN(A1),"Packers","Chiefs","Cowboys","Bears","Ravens"),":",A1))

Then you should be able to fill another four columns to the right and all the way down.

Upvotes: 0

Related Questions