Forum Discussion
Using IF, AND based on multiple criteria
Hello, In my attached spreadsheet, I need a formula for the values in column E. If C=H2S and D=EDM, then the value needs to be B*150 If C=H2S and D=FTM, then the value needs to be B*225 If C...
Monica Bossert I'd do this with an INDEX MATCH MATCH instead, as it will be easier to extend to more codes in the future - see attached.
This worked, thank you!
