VLookup

[Mary]

I have a spreadsheet and I am using vlookup. This is
working fine, however, in my source spreadsheet I have a
field called P.O.# and it may have one value or several.
But in the spreadsheet where I am looking up the data to be
put into the first spreadsheet, the P.O. # is on several
lines. I need to somehow separate the data but place it on
separate rows. See the example below:


Source Spreadsheet


CustomerID S.O.Date S.O.# P.O. #
Joan 9/29/2003 9617 15223,15222,15224
B.C.A. 10/17/2003 9691 15283
Gates 10/17/2003 9701 15285


Second workbook


S.O.# P.O. Date P.O # VendorID
9649 7/10/2003 14885-Stock Hollander Glass
9691 7/15/2003 14907-G&B silkwood Jordan
9701 7/17/2003 14913-Jordan
9725 8/19/2003 15038-Dyess Pas Point Glass
9726 9/10/2003 15113A-Stock Dyke Industry

 

[Sean]

Try using Data/Text to Columns, then choose "Delimited"
and it looks like you could use Comma's to recognize what
seperates the PO#'s. This will put the Codes in seperate
columns.

 

[Mary]

This works but, is it possilbe to have it split the data
but put the values in every other column. I need to put a
date in betwwen each P.O. #. I need to put the date of
each purchase order.

Mary

 

[A.W.J. Ales]

Mary,

I 'am afraid that that isn't possible, but can't you just insert a (or more)
column(s) after you've done your conversion?

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *