Using 'if" To Return An Entire Row?

J

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
 
B

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)
 
J

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
 
Top