Hello,

I've spent hours on this and still can't get the formula right. I have a
list of phone numbers in column A on worksheet 1 and another list phone
numbers in column A on worksheet 2. I need a formula on worksheet 1 that
says if the phone number matches on worksheet 2, then place the contents from
column D on worksheet 2 into worksheet 1. The phone number will match more
than once on worksheet 2, however, so I need will need Excel to be able to
return multiple values (which is all text). Thank you in advance for any
help you can provide!