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

We now have the Xlookup function in Excel 365 which is great replacement for Vlookup. But there is one thing which I believe should have been added to the Xlookup function i.e. return output for the nth occurrence of a lookup value. But thanks to excel, this can still be done using the new lambda function. So lets create our own Nlookup function to take care of this problem.

Timestamps:
0:00 What we aim to achieve!
2:53 Use existing excel functions to find nth occurance of lookup value
6:42 Create NLOOKUP () using Excel LAMBDA to find nth occurance of lookup value

• #education
• #vlookup_limitations
• #xlookup_limitations
• #lookup_2nd_value
• #lookup_nth_value
• #excel_functions
• #excel_advanced
• #excel_365_formulas
• #microsoft_365_formulas