Lookup and Return a a the Unique Values

tamiz.vedachalam

I have requirement to review the TYPE and return the Food value in unique list

The outcome should like this

written a formula like this like this

=IFERROR(INDEX({Range of "Type"}, MATCH($[Food], {Range of Food}, 0)), "No Match")

the outcome is coming like this. Only the 1st row is appearing and not the others

Paul Newcome

You will need to insert a text/number column (called "Number" in this example) and manually enter the numbers starting with 1 and going through however many you anticipate plus a recommended buffer in case there are more than anticipated.

Then you would use

=IFERROR(INDEX(COLLECT({Range of Food}, {Range of "Type"}, @cell = "Food"), Number@row), "")

Paul Newcome

You will need to insert a text/number column (called "Number" in this example) and manually enter the numbers starting with 1 and going through however many you anticipate plus a recommended buffer in case there are more than anticipated.

Then you would use

=IFERROR(INDEX(COLLECT({Range of Food}, {Range of "Type"}, @cell = "Food"), Number@row), "")