Picking from one of three choices

[HappyChappy]

Can anyone help.
I have two sheets Sheet1 has d1 with either one two or three in it cell a1 have "fred" in it" b1 have "mary" c1 have tim"
Sheet2 has d1=Sheet1!d1 if d1 has two showing the answer in a1 needs to show "mary" therefore choosing the middle number from my list on sheet1
Hope this makes sense thanks in advance for any help

 

[Peter_SSs]

2nd source is Sheet1 $Q$1:$Q$3

Thanks. try this

=INDEX(Sheet1!$B$40:$D$40,MATCH(Sheet1!$D$1,Sheet1!$Q$1:$Q$3,0))

 

[HappyChappy]

Perfect you sir are a gentleman thank you for the expect and prompt help 5 Star

 

[Peter_SSs]

You're welcome. Thanks for the follow-ip.