troubleshooting Question

excel vba lookup function with multiple data elements in a single cell

Avatar of joetwa
joetwa asked on
Visual Basic ClassicMicrosoft Excel
4 Comments1 Solution257 ViewsLast Modified:
looking for someone to help me write a quick and dirty function  to look at ID numbers in a cell and to return a corresponding name (or names) associated with the ID number(s) via a lookup pointing to a separate array

IDs would be numeric in this format, seperated by "; " where there are multiples - eg
100  (for only one ID in a cell)
100; 101; 108 (for 3 IDs in a cell)
etc.
see attached file for more detail
thanks in advance

sample.xls
ASKER CERTIFIED SOLUTION
Jorge Paulino
IT Pro/Developer
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros