Max - Of course, you were correct. I now know how to get the results I wanted.
Thanks for your patience.
--
Jim T


"Max" wrote:

Jim,

Your orig posts' core lines we
.. a named range of 10 golfers called TEAM1GOLFERS
.. How do I get all 10 names to show?

The 2 methods suggested earlier should have worked. F2:F11, B2:B11 should
have returned the correct results if you had played through the steps
suggested.

You must include the "=" sign at the beginning of the formulas as suggested.
There's no need for any preceding "+" sign but the "=" sign is necessary.

Perhaps you may wish to try again ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jim Tibbetts" wrote in message
...
Max - Thanks for the comeback. I'm not sure that's exactly what I am
looking
for. Assuming the range of TEAM1GOLFERS is C2:C11 on page TeamData (which
it
is), I can bring in each golfers name in another place by entering
+TeamData!C2 in a cell and then copying it down. Maybe I'm missing
something,
but isn't that what INDEX is doing? It only brings in one name. I'm
wondering
if there is a single function (or combination of functions in one cell)
that
will bring in the entire list of 10 names in TEAM1GOLFERS.

Thanks again.
--
Jim T