When using the vlookup I can get it to work. this is the formula I have.

=VLOOKUP(C3,'Family - Pay Cycle'!$B$2:$E$20,4

C3= Last Name
'Family - Pay Cycle'!$B$2:$E$20,4=My look up table.

Now the last name can represent 3 different familys. How can program so if
the last name has three different familys i can also pick up the First name.
To make sure I capture the correct family

ps(D3=First Name)

thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1

so you search by the surname which is column 1 so that means the first name
must be column 2,try =VLOOKUP(C3,'Family - Pay
Cycle'!$B$2:$E$20,4,false)&"-"&VLOOKUP(C3,'Family - Pay
Cycle'!$B$2:$E$20,2,False).In your return cell you will have whatever the
value in column 4 with the first name,seperated by a -
--
paul
remove nospam for email addy!



"Darts via OfficeKB.com" wrote:

When using the vlookup I can get it to work. this is the formula I have.

=VLOOKUP(C3,'Family - Pay Cycle'!$B$2:$E$20,4

C3= Last Name
'Family - Pay Cycle'!$B$2:$E$20,4=My look up table.

Now the last name can represent 3 different familys. How can program so if
the last name has three different familys i can also pick up the First name.
To make sure I capture the correct family

ps(D3=First Name)

thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1