vlookup multiple data
I would suggest you not do this.
Why don't you just put each lookup value in its own cell?
--
Biff
Microsoft Excel MVP
"Art" wrote in message
...
No, the quotes are used just to indicate the actual values of the cells.
I replied to Jacob also asking if the vlookup could do more than 2 items,
too. For example
Sheet 1
A1 = "Me, You, Him, Her"
B1 = (after vlookup) "Art, Joe"
Sheet 2
A1 = "Me" and B1 = "Art"
A2 = "You" and B2 = "Joe"
A3 = "Us" and B2 = "Patrice"
A4 = "Him" and B2 = "Mike"
A5 = "Them" and B2 = "Oscar"
A6 = "Her" and B2 = "Janet"
Then Sheet1B1 should display "Art, Joe, Mike, Janet".
Thanks!
"T. Valko" wrote:
Sheet 1
A1 = "Me, You"
B1 = (after vlookup) "Art, Joe"
Sheet 2
A1 = "Me" and B1 = "Art"
A2 = "You" and B2 = "Joe"
Does your data actually contain all those quotes?
--
Biff
Microsoft Excel MVP
"Art" wrote in message
...
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
cell (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!
.
|