LinkBack URL
About LinkBacks
I am doing a multiple criteria search using INDEX MATCH. The code works well to produce a formula, but what I really need it to do is return the row number when it finds the multiple match.
Please Login or Register to view this content.
I am doing a multiple criteria search using INDEX MATCH. The code works well to produce a formula, but what I really need it to do is return the row number when it finds the multiple match.
Please Login or Register to view this content.
Last edited by cabroncito29; 09-30-2015 at 02:24 PM.
post deleted
Last edited by protonLeah; 09-30-2015 at 02:35 PM.
Ben Van Johnson
Sorry about that!
So I love the idea of INDEX MATCH for a multiple criteria search. I have 2 separate worksheets and pull 3 pieces of data from one and search for the appropriate match on the other. I have figured out how to return a value, but can I have the code return the row number?
Please Login or Register to view this content.
Remove the INDEX function in your formula and add +1 to the MATCH result because your search range starts at row 2
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Why are you INDEXing on T2:T10? Seems, all you need is the MATCH alone. It will return the smallest (first) row number in the three columns.
Please Login or Register to view this content.
cabroncito29 , please do not post duplicate threads. I will combine this 1 with your other 1 because they both have comments (normally I would close 1 of them)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Works awesome! Thank you so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks