IFS Function working for some results but not others, but all saying 'True'?
Hello!
I'm really hoping someone can figure out what's going wrong here, because I'm at a loss.
On the Fill Out Form sheet, column K should be reacting to the drop down option selected in column J, and displaying the corresponding data from column K in the Drop Down Information Sheet (the 'Points Total' column in the Fiction table).
The strange thing is it's working for most of the drop down options, but not for General fiction, *Crime* and *Comics*, and to my eyes those options are formatted exactly the same as everything else. It's even recognising the statements as true, so it's not mismatches in the phrase, and the correct Drop Down value to show, but then it's returning the "Input Needed" backup value.
I'm using this IFS formula:
=IFS(J7="General fiction",'Drop Down Information'!$K$5,J7="Literary fiction",'Drop Down Information'!$K$6,J7="Classics",'Drop Down Information'!$K$7,J7="Historical fiction",'Drop Down Information'!$K$8,J7="Crime, mystery, thriller, and suspense",'Drop Down Information'!$K$9,J7="Action/Adventure",'Drop Down Information'!$K$10,J7="Fantasy",'Drop Down Information'!$K$11,J7="Science Fiction",'Drop Down Information'!$K$12,J7="Horror",'Drop Down Information'!$K$13,J7="Romance",'Drop Down Information'!$K$14,J7="Comedy",'Drop Down Information'!$K$15,J7="Young adult",'Drop Down Information'!$K$16,J7="Comics, graphic novels and manga",'Drop Down Information'!$K$17,J7="Poetry",'Drop Down Information'!$K$18, TRUE, "Input Needed")
Thank you do much for any help. I'm hoping it's something really silly I've overlooked and an easy answer?
(Also please excuse the messy look - it's a very new spreadsheet!)
WLC Book Purchase Suggestions - Editable (Hopefully you should be able to Request Access, really sorry if not!)
UPDATE: Changed to XLOOKUP and it's all working fine - thank you so much for such quick responses, and introducing me to a new formula type!
[link] [comments]
Want to read more?
Check out the full article on the original site