how to link a dataset with specific multiple variables to unique values in excel?

Copper Contributor

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!

1 Reply

@maess 

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.