VLookUP with multiple results.

[vetrox]

Greetings fellow members.
I'm in need of a formula that gives me a list of names that have had their orders returned.

This is an example of what the table looks like.
amwdx95.png

It has approximately 1.5K entries (or in other words, I would need it to lookup the entirety of columns C and E), and what I need it to do is to give me a list of all the names (they're in column C) that have their E column value as "Vraćeno" (means returned in my native). Another thing that I need to note is that the list needs to be presented on another sheet. The sheet that it needs to lookup from is called "Lista".

Grateful for any help provided.

[JBeaucaire]

1) Highlight the titles
2) Turn on the Autofilter
3) Filter column E by the value you want
4) Copy the visible rows to another sheet, if you really need to

[mongoose36]

Something like...

Please Login or Register  to view this content.

[JBeaucaire]

Note, this is not the VBA forum, it is not typical to provide VBA solutions in this area, at least not without explaining more about what it is and how to apply it. FYI.

[mongoose36]

Sorry disregard...I should've realized this was not in the VBA forum!

[vetrox]

Sorry disregard...I should've realized this was not in the VBA forum!

If you'd elaborate on how to use it, I gladly would.

[JBeaucaire]

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

[mongoose36]

Yup that's thats how you get started! Thanks @JBeaucaire! Also you will need to add a sheet named "Destination" for `Worksheets("Destination").Range("A1")` or change the code to match the name of the sheet you wish to dump the rows into. @JBeaucaire the only think I wasn't quite sure of is how the autofilter would handle the accent marks, ć. I know this is a particular ascii code, but wasn't sure how to get that into the VBA. Any thoughts?

You can also delete the following two lines from the code...they are unnecessary (I decided to go a different way).

Please Login or Register  to view this content.

[JBeaucaire]

the variable "wb" is also unneeded

[mongoose36]

Here is the corrected code...

Please Login or Register  to view this content.