I was wondering if it was possible to search for some text in an array and then return all the values in another column where that text appears.
A sample workbook has been attached
Thanks in advance
I was wondering if it was possible to search for some text in an array and then return all the values in another column where that text appears.
A sample workbook has been attached
Thanks in advance
Do you know how to use UDFs?
http://www.ozgrid.com/VBA/TwoColLkUp.htm
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
No, sorry, I have never seen those before. Is there not a way to use an index and match function and instead of matching the exact wording you can match part of the text in the cell i.e. =A1&"*" or something like that?
Yes, but it would be so complicated that you'd never be able to edit it if anything changed in your workbook - and it would be slow.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks