IF statement with multiple

[kiwicanta7]

Hello All!

So I have cells that may or may not have user inputs that would determine how many returns are provided. The statements basically go down the list to determine if the 25th slot is filled out and if not checks if the 24th slot is filled out etc. If the 25th slot is filled out it provides the relevant information in E3 for all 25 slots, if only 24 slots are filled out F3 provides the correct information then etc. Using the code below (though done 25 times in my code) I'm trying to get it to only spit out the relevant information if that cell is not blank. Any ideas why it is outputting all 25 slots regardless of if there is any input in the cell?

=IF(AND('START HERE'!B198<>""),E3,
IF(AND('START HERE'!B194<>""),F3,
IF(AND('START HERE'!B190<>""),G3,
IF(AND('START HERE'!B186<>""),H3,
etc.

Thank you for the help!

 

[kweaver]

Would you use XL2BB to provide some relevant sample data and the solution(s) you expect?

 

[kiwicanta7]

Nevermind, it was an issue with the email button I had setup. It was referencing the wrong cell. Thank you for your response!

 

[kiwicanta7]

Nevermind, it was an issue with the email button I had setup. It was referencing the wrong cell. Thank you for your response!