Forum Discussion
Excel - five variables - HELP!!
Hi all, I need help with something. I have variables and would like to set up a formula which automatically put in the result. The first five are my variables. Each variable has different...
You have provided the criteria you wish to satisfy but failed to describe the data source that you will need to select from. Assuming you have a table with the same headings as your criteria, you could seek the first match or list multiple matches
"First match"
= XLOOKUP(TRUE, BYROW(variables = required, AND), PREISAUSCHLAG)
"List of matches"
= FILTER(PREISAUSCHLAG, BYROW(variables = required, AND))