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:
_______________________________ _______________
_______________________________ _______________
_______________________________ _______________
_______________________________ _______________