look up data within VBA

[Evolta]

Hello,

I'm having a small problem here, or rather a question.
I have 3 values (firstname, secondname, place) that I need lookup in a list of items.
I want to return the row where all 3 the names are found in the list.
Problem of course is that each value can appear more then once in the list, but the combination is always unique.

Something like this would be nice:

Please Login or Register  to view this content.

But that doesn't work, so anyone with better ideas is more then welcome to share them

[Klaster]

You could simply add if-statements and check for the 2ndname and place in the row the other one is found.

[XOR LX]

Hi,

Perhaps this, assuming your source data is in columns A:C beginning in row 2, and that the 3 search strings for First Name, Last Name and Place are in cells E2, F2 and G2 respectively:

Please Login or Register  to view this content.

Regards

[JOHN H. DAVIS]

Can you post a sample file with some data?

[Evolta]

I will upload a document as is. (new version that doesn't work)

Main concern is with the selection of customers (so a self made search option)
You'll notice that I added company there
Klantbeheer.xlsm