ie it matched the first lot to the name of the builder
but it did not do it for the rest of lots I know
are listed for that same builder.

well <g, it was assumed (stated) in the suggestion that:
"Names in col C are assumed *unique*" (in Sheet1)
as MATCH will return only the first match found for the name

Here's an option to try out since you have
repeated names involved in Sheet1

Suppose we have
In Sheet1, in cols A to C
-------------
Lot# Price Name
1110 3000 DEF
1111 4000 ABC
1112 1000 GHI
1113 2000 DEF
1114 1000 ABC
1115 1000 GHI
1116 5000 DEF
1117 2000 ABC
1118 1000 GHI
etc

List across in say, E1:G1
the *unique* names: ABC, DEF, GHI

Put in E2: =IF($C2="","",IF($C2=E$1,ROW(),""))
Copy across to G2, fill down by as many rows
as data is expected in cols A to C, say down to G500?

In Sheet2
-------------
List across in A1:C1
the unique names: ABC, DEF, GHI

Put in A2:

=IF(ISERROR(SMALL(INDIRECT("'Sheet1'!"&CHOOSE(MATC H(A$1,Sheet1!$E$1:$I$1,0),
"E:E","F:F","G:G")),ROW(A1))),"",OFFSET(Sheet1!$A$ 1,MATCH(SMALL(INDIRECT("'S
heet1'!"&CHOOSE(MATCH(A$1,Sheet1!$E$1:$I$1,0),"E:E ","F:F","G:G")),ROW(A1)),I
NDIRECT("'Sheet1'!"&CHOOSE(MATCH(A$1,Sheet1!$E$1:$ I$1,0),"E:E","F:F","G:G"))
,0)-1,))

Copy across to C2, fill down by as many rows
as was done in Sheet1, viz. to C500

This'll extract all the lot #s for each name
from Sheet1, i.e. for the sample data above
you'll get:

ABC DEF GHI
1111 1110 1112
1114 1113 1115
1117 1116 1118

Adapt / extend to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sal" wrote in message
...
Sorry me again...

It worked on one cell but then would not copy down correctly.

ie it matched the first lot to the name of the builder but it did not do
it
for the rest of lots I know are listed for that same builder.