Table Function

[SVTF]

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?