Importing Multiple Data On the Same Row

[Tiziano]

I am using Excel 2000.

I have a spreadsheet with part numbers in col. A (the same
part number can appear multiple times) and purchase order
numbers in col. B (a purchase order number is never shared
by multiple instances of the same part number). The list is
very long!

I need to import this data into another file which shows (in col.
A) all the part numbers that we have (each part number appears
only once in this spreadsheet). The problem is that I have to
list ALL the purchase order numbers related to the same part
number on one row, starting in col. C... So, while for some part
numbers there could be no existing purchase order number or
only one purchase order number, for others there could be several
purchase order numbers to list on the same row! (Probably ten
purchase order numbers at the most.)

Is this possible with an Excel formula?

 

[Andre Croteau]

Hi,

I can suggest to visit the following site to get your answer, and look at
arbitrary lookups

http://www.cpearson.com/excel/lookups.htm

In your cell say C3, you would have the 1st lookup, Cell D3 the second, and
so on.(the formula could reference the order value in cells C1 to L1, you
could have numbers 1 to 10)
You could also include an "iserror" formula to eliminate the REF!# result if
you dont't get to the ten purchase order references.

Hope this helps

André

 

[Tiziano]

Thanks, André! That seems to be exactly what I am looking for.
I will test it out on Monday at work.
----
Tiziano

Hi,

I can suggest to visit the following site to get your answer, and look at
arbitrary lookups

http://www.cpearson.com/excel/lookups.htm

In your cell say C3, you would have the 1st lookup, Cell D3 the second, and
so on.(the formula could reference the order value in cells C1 to L1, you
could have numbers 1 to 10)
You could also include an "iserror" formula to eliminate the REF!# result if
you dont't get to the ten purchase order references.

Hope this helps

André