trying to populate certain filelds from one spreadsheet into another. One
of the fields in sheet 1 will state yes(sheet 1 C2)if the yes condition is
populated i wnat to bring the name and number of to sheet 2( sheet1 a2 and
b2) if the condition is populated with a no(sheet 1 C2) the formula should
check the next cell (sheet 1 C3)to see if the condition is met with a yes
Sheet 1

NAME EXTENSION VOICE MAIL
BARBARA ABLER 2723 Yes
PHILIP DISMORE 2773 Yes
LEE CLARKSON 2748 No
DAWN BAKER 2766 No
JOE SMITH 2762 Yes
MIKE JONES 2736 Yes
HAROLD MIKES 2799 No
PAMELA OCONNOR 2712 Yes

Sheet 2
Voicemail Users Full Name: Voicemail Users Mailbox Number:
_______________________________ _______________
_______________________________ _______________
_______________________________ _______________
_______________________________ _______________

How about an alternative?

Apply Data|Filter|autofilter to your range.
Filter by that yes/no columns to show just the yes's.

I find that life is much simpler if I can keep my data in one spot an apply
filters to see the data that I want to see.


Barbara wrote:

trying to populate certain filelds from one spreadsheet into another. One
of the fields in sheet 1 will state yes(sheet 1 C2)if the yes condition is
populated i wnat to bring the name and number of to sheet 2( sheet1 a2 and
b2) if the condition is populated with a no(sheet 1 C2) the formula should
check the next cell (sheet 1 C3)to see if the condition is met with a yes
Sheet 1

NAME EXTENSION VOICE MAIL
BARBARA ABLER 2723 Yes
PHILIP DISMORE 2773 Yes
LEE CLARKSON 2748 No
DAWN BAKER 2766 No
JOE SMITH 2762 Yes
MIKE JONES 2736 Yes
HAROLD MIKES 2799 No
PAMELA OCONNOR 2712 Yes

Sheet 2
Voicemail Users Full Name: Voicemail Users Mailbox Number:
_______________________________ _______________
_______________________________ _______________
_______________________________ _______________
_______________________________ _______________




--

Dave Peterson