Using 'if" To Return An Entire Row?
 

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

Using 'if" To Return An Entire Row?
 

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" wrote in
message ...

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

Using 'if" To Return An Entire Row?
 

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


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=515943