jeffreybrown
Well-known Member
- Joined
- Jul 28, 2004
- Messages
- 5,152
I've used this UDF for many years to return all matched results and it works fine. On this one particular workbook it does not immediately return the results until I go to the source tab and activate a cell and hit enter. After that, the results return fine. Obviously this will not work for the customer.
https://www.mrexcel.com/forum/excel-questions/169996-vlookup-multiple-results.html#post830620
I'm using VBA to fill in the UDF results, but again, no results. I know it has something to do with this workbook and it's not mine, so I can't rebuild it or that would be my preferred option.
Can anybody offer a suggestion? Can I clarify anything to help further?
https://www.mrexcel.com/forum/excel-questions/169996-vlookup-multiple-results.html#post830620
I'm using VBA to fill in the UDF results, but again, no results. I know it has something to do with this workbook and it's not mine, so I can't rebuild it or that would be my preferred option.
Can anybody offer a suggestion? Can I clarify anything to help further?