Excel - five variables - HELP!!

Question

Hi all,&nbsp;I need help with something.&nbsp;I have variables and would like to set up a formula which automatically put in the result.&nbsp;The first five are my variables. Each variable has different options. The last one is my result.How can I set up the formula?&nbsp;Thank you for your help!&nbsp;

detlef_lewin · Answer

Frankfurt99&nbsp;Please delete your post and write a new one.Consider providing a sample workbook with the intended result.&nbsp;

sergeibaklan · Answer

Frankfurt99&nbsp;
What is the logic behind for the result?

peterbartholomew1 · Answer

Frankfurt99&nbsp;You have provided the criteria you wish to satisfy but failed to describe the data source that you will need to select from.&nbsp; 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))

Forum Discussion

Excel - five variables - HELP!!

3 Replies

Resources