Argh! Merged cells! Argh!

Let me see what I can do. It may be a while. I'm getting ready for a dinner
break.

Biff

"DarnTootn" wrote in message
...
I posted here

javascript:ol('http://download.yousendit.com/A3DC28565957C69A');
"Biff" wrote:

Post the *EXACT* formula that you're using.

Biff

"DarnTootn" wrote in message
...
Opps... Biff I thought it was going to work.... but after the second
line
it
gives me a #NUM error and it is not pulling up the right name with the
four
digit crew number... It brings up a name but from someone elses crew


"Biff" wrote:

Here's a small sample file that demonstrates this:

List_names.xls 15kb

http://s65.yousendit.com/d.aspx?id=3...W0G3N0SXXWLA2T

Sheet2 has the employee list.

For your situation you'd need to copy the formula in A17 down 23 rows
to
cover the max number of employees in any one crew.

The formula can be shortened slightly but in an effort to make things
as
easy to understand as possible I left some sheet references in that
could
be
removed.

Biff

"DarnTootn" wrote in message
...
yes I do have a table with that info.. and no on the same size... I
will
have
anywhere from 3-23

"Biff" wrote:

Hi!

Does each crew have the same number of people assigned?

Do you have a table that lists the employees and their respective
crew
number?

Biff

"DarnTootn" wrote in message
...
I have already have my lists created.... Problem... in Cells
A17:A62
I
need
the list of employees names to display down the column by
selecting
the
number value in Cell A13...(A13 being a four digit crew code)...
Each
employee has a four digit crew number associated with them....
so
far
I
have
Cell G10 as a drop down list to select the crew name, which puts
the
crew
four digit number in A13. So now I need Cells A17:A62 to display
the
employee names down the column by using the value in A13... does
that
make
sense?? PLEASE NEED HELP