Using 'if" To Return An Entire Row?

[JENNYC]

Hello all!! Is there an "if" formula (or any other) that will return an entire row?

For example:
Column A has my salespersons names
Columns B - J have other info

i have my "master list" of all contacts, and then I have a separate sheet for each of my salespeople.

What formula would i use (if it is even possible) to have excel look for "Mike" on the master sheet & then return all the other info next to his name onto "Mike's sheet" each time it sees his name ?

Let me know if i need to explain that more clearly!
Thanks in advance for your time & help!

Jenny

[Bob Phillips]

In B2 say

=VLOOKUP($A2,Master!$A$1:$J$1000,Column(),False)

and copy across.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"JENNYC" <JENNYC.23p7qm_1140725409.9822@excelforum-nospam.com> wrote in
message news:JENNYC.23p7qm_1140725409.9822@excelforum-nospam.com...
>
> Hello all!! Is there an "if" formula (or any other) that will return
> an entire row?
>
> For example:
> Column A has my salespersons names
> Columns B - J have other info
>
> i have my "master list" of all contacts, and then I have a separate
> sheet for each of my salespeople.
>
> What formula would i use (if it is even possible) to have excel look
> for "Mike" on the master sheet & then return all the other info next to
> his name onto "Mike's sheet" each time it sees his name ?
>
> Let me know if i need to explain that more clearly!
> Thanks in advance for your time & help!
>
> Jenny
>
>
> --
> JENNYC
> ------------------------------------------------------------------------
> JENNYC's Profile:
http://www.excelforum.com/member.php...o&userid=19579
> View this thread: http://www.excelforum.com/showthread...hreadid=515943
>

[JENNYC]

thank you so much Bob! i have never used VLOOKUP before, so this will be a learning experience for me! thanks for pointing me in the right direction!

Jenny