Create NLOOKUP () function to find n'th occurrence of lookup value (something even XLOOKUP cant do)

[@AswinAGMFA]

Fantastic Video

[@premiertraininghub]

Thanks for watching

[@VINAY_DEVADIGA]

You can achieve the same result by using a very short Syntax as below and then if needed, convert that into a lambda function with 4 input parameters as defined below the formula
=INDEX(FILTER($B$3:$B$16,$A$3:$A$16=D3),E3)
$B$3:$B$16 is the item names; in your case--> fruit names
$A$3:$A$16 is the dates
D3 is the individual item you want to evaluate
E3 is the Nth value you wish to obtain
In order to avoid errors on selection of the Nth value you can use the formula
=SEQUENCE(COUNTIF($A$3:$A$16,D3))
and reference the above to a Drop Down list
Once done, user can only select the numbers from the drop down

[@kawsarahmad]

Excellent video! Very well explained, thank you!

[@premiertraininghub]

You're very welcome!

[@aneilpope]

Amazing!

[@premiertraininghub]

Thanks!

[@joycenaicker6251]

Thank you.

[@premiertraininghub]

You're welcome!