A question regarding of search data using VLOOKUP

[MeSH16]

Untitled.png

Based on the screenshot above.. it is possible to search either ticket #, body # or name of violator using VLOOKUP?

My internet is ******* slow for now. So I'll type the code for now

Violations Column

Please Login or Register  to view this content.

Address Column

Please Login or Register  to view this content.

Officer Apprehension Column

Please Login or Register  to view this content.

UPDATE:

search using vlookup.xlsx

If not possible can you provide other alternatives? thanks in advance

[sktneer]

You may try something like this....

In M2

Please Login or Register  to view this content.

[MeSH16]

You may try something like this....

In M2

Please Login or Register  to view this content.

thanks sktneer! it works perfectly! I will apply this code on the actual spreadsheet.. will add and modify since it's only a sample... I will update again if my modification will fail.... +REP to you

[sktneer]

You're welcome and thanks for the feedback as well.