LinkBack URL
About LinkBacks
Hello all,
Say I have a 2 column array. I want to search the first column of the array for value XYZ and return the value from the corresponding second column. How do I do this?
New to arrays-How to VLOOKUP a VBA array?
Hello all,
Say I have a 2 column array. I want to search the first column of the array for value XYZ and return the value from the corresponding second column. How do I do this?
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Please Login or Register to view this content.
Elegant Simplicity............. Not Always
Iterate is the most common application (provided its reasonable in size). A simple example:
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Thank you all for your solutions +1
In the end I went with the solution from AlvaroSiza. (In one case I needed to lookup the value in the second column and return the value in the first column).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks