I have a similar situation

i have one tab labeled "Schedule" that has a list of names in column
E3:E10000, a list of cities in column F3:F10000, a list of states in column
G3:G10000, and a list of numbers in column C3:C10000

Then on another tab labeled "Calculations" i have each city listed once in
column C3:C114, followed by its state in column D3:D114, and a number in cell
A1

I want the Calculations tab to find all names with that number in A1, in the
city and state on the row it is on, and list them horizontally in the same
row from columns G:P (max of 10 names)

I edited the formulas above to look like this:

INDEX(Schedule!$E$3:$E$10000,SMALL(IF((Schedule!$C $3:$C$10000=$A$1)*(Schedule!$F$3:$F$10000=$C4)*(Sc hedule!$G$3:$G$10000=$D4),ROW(Schedule!E$3:E$10000 )-ROW(Schedule!E$3)+1),COLUMNS($A:A)))

I entered it as an array formulas and expanded the array over to column P
and down to row 114 and entered as array again ... but populates the same
name in every cell in that range (the first name it found)

Any help on what I am doing wrong?

"Max" wrote:

You're welcome (from us) !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Minerva" wrote in message
...
Appreciate all your help
Thanks.