Nested =IF formula not working - PLS HELP!!

[Rana Gray]

Hey Everyone I've been trying to figure out how to write this formula and I'm open to using VBA if need be but I'm super new to it so my knowledge is limited.

Summary: I'm trying to get CELL = [sheet2] X but if X is Blank then CELL = [sheet2] Y, if Y is Blank then CELL = [sheet2] Z, and if [sheet2] Z is Blank then leave Blank

=IF('Product Selection (1)'!K14=0,'Product Selection (1)'!K22,IF('Product Selection (1)'!K22=0,'Product Selection (1)'!K36,IF('Product Selection (1)'!K36=0,"")))

I would use VBA Case Function of IF/IFELSE but I don't know how to start off the sub.

Any advise would be super amazing!! Thanks a bunch in advance!

 

[Fluff]

Hi & welcome to MrExcel.
Maybe

=IF('Product Selection (1)'!K14<>"",'Product Selection (1)'!K14,IF('Product Selection (1)'!K22<>"",'Product Selection (1)'!K22,IF('Product Selection (1)'!K36<>"",'Product Selection (1)'!K36,"")))

 

[Rana Gray]

Hi & welcome to MrExcel.
Maybe

=IF('Product Selection (1)'!K14<>"",'Product Selection (1)'!K14,IF('Product Selection (1)'!K22<>"",'Product Selection (1)'!K22,IF('Product Selection (1)'!K36<>"",'Product Selection (1)'!K36,"")))

Can I just say you are my HERO!!!! I know this maybe asking a lot but I want to learn could you explain what this formula says that way I can use it in other situations if need be?

 

[Fluff]

It says if K14 isn't blank use K14 else if K22 isn't blank use K22 etc

 

[Rana Gray]

It says if K14 isn't blank use K14 else if K22 isn't blank use K22 etc

Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.