On 26 Jun 2005 01:45:49 -0700, "gordo" wrote:

Can someone please help
I have the following workbook with a selection of the data below:

INUMBR ILONGD WHHAND WHCOMM WHPEND WHSLOT01
175552 WHIRLPOOL AWM1404/4 1400RPM WASHER (AAB,5KG) 154 18 0 R4015
247294 BOSCH WFL2067 1000RPM WM(CLASIXX,A+AC,6) 111 2 0 R2023
247294 BOSCH WFL2067 1000RPM WM(CLASIXX,A+AC,6) 111 2 0 R4007
247294 BOSCH WFL2067 1000RPM WM(CLASIXX,A+AC,6) 111 2 0 R4018
247308 BOSCH WFO2467 1200RPM WM (CLASIXX,A+AB,6) 128 29 0 B1043
What i am trying to do is for example:
Inumber 247294 appears above 3 times with different locations , the
inumber being in A1-A1000 (Some Inumber appear more than once) and the
Locations in h1-h1000.
I have a seperate workbook with a list of Inumbr which is only
displayed once. What i want to do is bring back all the locations for
the Inumber.
For example : 247294 has three locations R2023,r4007,r4018. Using
vlookup only brings back the first location (r2023)and dosent allow the
second value and third respectively.
Is there any way of displaying these.
Note =cell is not an option (workbook changes)

Many thanks

Gordon

You could adapt one of the solutions provided you in your very similar request
which you posted yesterday.


--ron