Forum Discussion
maess
Feb 23, 2024Copper Contributor
how to link a dataset with specific multiple variables to unique values in excel?
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
- SergeiBaklanDiamond Contributor
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.