vlookup w/ multiple data in a single cell

A

art

Is it possible to have a cell contain two pieces of informaton (e.g., A1 ="Me
You"), a vlookup statement to look for each pece of informaton in that cel
(e.g., first "Me", then "You") in another sheet, and display the match in B1?

Sheet 1
A1 = "Me, You"
B1 = (after vlookup) "Art, Joe"

Sheet 2
A1 = "Me" and B1 = "Art"
A2 = "You" and B2 = "Joe"

I tried all different kinds of =VLOOKUP with different functions, and I
can't figure t out, of course I assume its possble to even use VLOOKUP in
this way. Perhaps I need to use a macro?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup multiple data 11
VBA Coding Help for Beginner 0
VLOOKUP & Data Validation 0
Vlookup and return sheet name also 2
Dragging a formula down isn't working - where am I going wrong? 1
Vlookup to reference offset 1
Using a vlookup to search multiple criteria for one result? 7
Multiple VLOOKUP in an IF statement 2

Top