Hey,
I have a list of products that I want to lookup against a big database of products. The difficult part is that one product can have multiple matches in the database and I need to have all matches come up in the results (unlike with vlookup). Also each product has multiple criteria that I want to copy down to the results page.
I made a mockup document with hopefully a little bit of a more clear explanation. In reality the database has around 100k rows of data.
Greetings,
Bassie
Why go through all that trouble when all you have to do is sort The table on Col 3 to get the same result...
OR
Is this not the exact setup of your actual file...I suggest uploading a sample file representing your actual file data
Please Login or Register to view this content.
Last edited by sintek; 03-28-2022 at 09:50 AM. Reason: Removed file...
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
My effort attached
Here's another option...won't be much difference in timing...
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks