Hi All,
VBA Newbie here. I have an excel file that has one million rows and a VLOOKUP is taking far too long. I understand that a Macro would save some time? Does anyone know what that code would be? I have attached an Excel file which I am hoping will help.
Thanks in advance for any and ALL help!
Sean
You are always looking up a value that's on the same line and get the result on the right of that lookup column ???
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yes, both columns will always be the same. I believe that is what you are asking? Thanks for looking into it!
Then why not just put a reference to the cell in column O ? Or am I missing something ?
Assuming BA and BB columns are free, the folowing code works
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 09-19-2017 at 11:57 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks