Table Function

Hello,

So I have this basic workbook:

Sheet 1 will be the main sheet with 7 headers.

The Analysts and Team Leader Header I want to reference tables on Sheet 2.

On sheet 2 there are two colums Analysts and Team Leaders.

What I want to happen is when you start to type a name on Sheet 1 under one of the above mentioned Headers it will Search the corresponding header on Sheet two and fill the name without having to do like a data Validation.

And Sheet two will have people added/removed from time to time so is there a way to make the ranage adjust accoridngly?

I was trying something with Insert/Define name .. but not sure that is the way to go?

Does the above make sense?

Why should it not do data validation? If you don't, you may have names in Sheet1 which are not in your reference tables.

I think you should and so the attached would be the best approach?

Originally Posted by pr4t3ek

Why should it not do data validation? If you don't, you may have names in Sheet1 which are not in your reference tables.

I think you should and so the attached would be the best approach?

The problem is the list under analysts could get as long as 300 people.

The scrolling would take longer then typing the full name in.

The only names that would be entered in sheet 1 would be the same names that in the refference on sheet 2

Maybe this will help. It is still usign data validation but no errors are displayed if the wrong name is entered...

Originally Posted by pr4t3ek

Maybe this will help. It is still usign data validation but no errors are displayed if the wrong name is entered...

Thanks looks like I am going with this.