Feb 23 2024 09:46 AM
I have a dataset (+100 lines) in excel where unique values correspond to specific multiple conditions. I want to create a table that return me the unique value if I fill in the corresponding values from the dataset. How can I do this without creating too long IF/IFS functions? Thank you!
Feb 23 2024 09:59 AM
Perhaps you may use any lookup function (VLOOKUP, XLOOKUP, INDEX/MATCH). for more details it's better you provide the sample illustrating how your data is structured.