Forum Discussion

Copper Contributor

Dec 20, 2023

Issues with Excel IF(And) statement

I am attempting to use an IFS statement that when 2 cells equal the criteria, I want it to return the data from another cell. What I've tried so far is: =IFS(AND(B7="A", A9="Buck Openings"), X17...

excel

Formulas and Functions

galley2

Copper Contributor

Dec 20, 2023

Thank you. I am looking for it to return the contents of cell Y178 or Y65. Any other ideas? Thanks.

OliverScheurich

Gold Contributor

Dec 20, 2023

galley2

Unfortunately i've missed the information that you want to return the data from another cell. @mtarler has meanwhile anserwed the question.