Forum Discussion
Solved
Functions
Is there any function in Excel that would be possible to search for an item in a table that has more than one correspondence, and therefore the correspondence would be chosen randomly? I know about t...
That could be like
=INDEX( FILTER(range, (range=value)), n)With your sample FILTER() returns an array of 5 elements and you only shall to say which of them to take, other words what shall be number n as second parameter for INDEX(). Thus you have one element every time.
Thank you Sergei, and I apologize for the delay of my answer.
IsraelFeferman , you are welcome