Hi,
there might be some infos about this on the forum already but I don't exactly know what to search about.

Here is what I need to do...

I have a table following this format:

ID Lot ID date
1 beer / ladies dd/mm/yyyy
2 beer dd/mm/yyyy
3 ladies dd/mm/yyyy
4 desert island dd/mm/yyyy
5 beer / ladies / desert island dd/mm/yyyy

The number of entries in the sheet varies everyday.

I would need a way to retrieve the list of all ID that contains a specific Lot ID.

The first idea I had was to write a macro that would define the last entrie in the sheet, then with this create a loop to test every Lot ID cell to determine if it contains the specific string I want to filter. If so, retreive the ID number with an offset, store it in an array and keep on....

Is there another way? Is this possible without a macro? Is there something more like an SQL query within excel that would give me the same result?

Thanks in advance for your time on this!
Regards