One thing you can do is to keep everything in the same thread. By continually
starting new threads, you discourage those who have thought about your problem
from following up with you. In addition, if you've tried one of the previous
suggestions, it would be useful to know what problems you've had with
previously recommended solutions.

This is the third new thread you've started with this same problem.

You did not respond at all to the suggestions in your first thread.
You stated you got a #VALUE! error to the suggestion in the second thread.
And now you've started a third thread which may have, at least some, people
starting from square one, without benefit of knowing what has worked and what
has not.



On 26 Jun 2005 06:19:03 -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)

cAN SOMEONE PLEASE EMAIL ME AT AND I WILL
SEND THE DOC IF REQUIRED
Many thanks


Gordon

--ron