data validation - list search

[Bejbas]

Hello everyone.
Few days ago I found excel file with macro which allows to searching using data validation.
Everything is ok but this macro doesn't work with offset and match formulas.
I tried modify macro code but I don't have enought knowledge about VBA.

Can I ask someone to help me with my issue?

For better imaginaiton my task below I sent video. Also I attached file excel.

I will be grateful for your help.


Regards,

[Pepe Le Mokko]

Nothing attached

[Bejbas]

I got a message : You are not allowed to post any kinds of links, images or videos until you post a few times.
Can i send link as private message for you?

[Pepe Le Mokko]

You can post a sheet without problems.
First click "Go advanced" then follow the " manage attachments" wizard.
Adding external links is not recommended even if you are allowed to

[Bejbas]

I attached excel file

[Bejbas]

Unfortunately I cannot upload video file even if I compress it for zip file.

[Bejbas]

hello,
Any ideas?