How to find or lookup the latest data if had same customer id of cell in sheet?

[ash]

Hi, i have unique and same customers id, which more than 5 id which same customer id. The question is how to find/lookup the id that required latest one of the id or latest date of the id?

 

[PabblyMember3]

Hi, i have unique and same customers id, which more than 5 id which same customer id. The question is how to find/lookup the id that required latest one of the id or latest date of the id?

Can you please elaborate your use case? I need some example to understand your requirements.

As far as the lookup method is concerned, the lookup method finds the first three matched rows no matter related the last updated.

What best you can do for this, just add a column and put a Date of updation there, you can search the value along with the data updated in the sheet.

I hope the above solution will work for you.