2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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!

submitted by /u/littlewanda
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#AI formula generation techniques
#formula generator
#big data management in spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#conversational data analysis
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#real-time data collaboration
#automation in spreadsheet workflows
#intelligent data visualization
#no-code spreadsheet solutions