Hello, Experts of Excel,
I'm currently in a quandary of a problem in which I have a list of data in which I'm hoping to return the values that match both column 1 and column 2 and would return values in columns C and D. I have a data sheet that contains all the returning values that those columns match. I have enclosed a sample of this problem. I have figured out that using VBA would be better used instead of using formula since the results would return a lot quicker and I don't have to worry about excel unexpectedly crashing due to the amount of data being looked up and returned. Below is a VBA code that returns the value of one column based on if columns 1 and 2 matches, but I'm hoping to get some guidance on how to build upon this code (or get a better code) to return more than one value.
Here's the code:
Any help with this would be appreciatedPlease Login or Register to view this content.
Thanks!
Bookmarks