Excel, vlookup

How can I produce the following vlookup?


jack      123
joe      456
james      789


jack / joe / james:      123 / 456 / 789
newparadigmzAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rspahitzCommented:
Not exactly sure what you're asking, but...
if your data is in columns A and B:

=VLOOKUP("jack", A:B, 2, false)
will give you 123

=VLOOKUP("joe", A:B, 2, false)
will give you 456

=VLOOKUP("james", A:B, 2, false)
will give you 789
0
newparadigmzAuthor Commented:
the number of names and /'s are unknown, need a formula that will work for that, and produce a 1 string result.
0
rspahitzCommented:
Without going into macros, Excel doesn't really support any kind of "looping" function other than things like SUM.

In your case, you may want to add a new formula to column C and D like this:
C1 =A1, D1 =B1
C2 =C1&" / " & A2, D2 =D1 & " / " & B2
copy the above formula down to the last row of names and you should have your results

To complete if you may want to put this in column E:
=C1 & ": " & D1
and copy it down.
0
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

SteveCommented:
newparadigmz,
Would you like a specific VBA solution creating to provide the functionality you require?
It would not be too hard to provide the required result using code, but not all people like to have code in their workbooks.

ATB
Steve.
0
newparadigmzAuthor Commented:
wanted to do it with a single formula, but just chopped it down and did it manually, thanks
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rspahitzCommented:
I offered a simple formula, but it had to be applied to several functions.  Did you try it? It would have saved you all that time you took to do it manually.
0
newparadigmzAuthor Commented:
no solution
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.