I need to step through a list of values and look up those values in a specific column in a different workbook. Basically a vlookup, but I need to result to be the row where the data was found, not return a column like vlookup does.
I need to do it in VBA as part of some other code I have.
Can soemone help me with how I can do that?
And, the search is on about 20,000 rows, there are hundreds of value searches, so fastest method is important.
Hello getgray,
Posting a sample workbook will get you an answer to your question.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
This will return the row number of the first occurance of "search Term" in column A.
=MATCH("search Term", [Workbook2.xlsx]Sheet1!$A:$A, 0)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
[SOLVED]Mike: Thanks, that gave me what I needed to go on.
Much appreciated guys, Scott
re [SOLVED], Please elaborate, I can't edit the original subject. You just want it in the reply text?Originally Posted by Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks