Forum Discussion

maess's avatar
maess
Copper Contributor
Feb 23, 2024

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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.

Resources