software

I am trying to retreive a date from one worksheet and place it on another.
Most often, I can match on company name, but there are times when the company
name is not unique and I have to use first/last name. The following is an
example of data on the worksheet I am trying to retreive from:Acutech 12/01/05 N Ms. LindaDendy
Adams Simpson LLP12/01/05NMr.JesseEvans
Adams Simpson LLP01/01/06NMs.DeborahHembree

I am using the following: =INDEX(Misc!$A:$C,MATCH(C38,Misc!$A:$A,0),2).
This will work and find the match, pick the date (from the second column),
but in the case where the company is Adams Simpson LLP, it will always choose
the 12/01/05 date. I need to find both. So I would need to match on the
first and last name if there is more than one entry of the company.

Can this be done (simply)? Thank you.

--
hgopp99
--
hgopp99

You have a response at your other post in .misc.

hgopp99 wrote:
gt;
gt; I am trying to retreive a date from one worksheet and place it on another.
gt; Most often, I can match on company name, but there are times when the company
gt; name is not unique and I have to use first/last name. The following is an
gt; example of data on the worksheet I am trying to retreive from:
gt;
gt;
gt; Acutech 12/01/05 N Ms. Linda Dendy
gt; Adams Simpson LLP 12/01/05 N Mr. Jesse Evans
gt; Adams Simpson LLP 01/01/06 N Ms. Deborah Hembree
gt;
gt; I am using the following: =INDEX(Misc!$A:$C,MATCH(C38,Misc!$A:$A,0),2).
gt; This will work and find the match, pick the date (from the second column),
gt; but in the case where the company is Adams Simpson LLP, it will always choose
gt; the 12/01/05 date. I need to find both. So I would need to match on the
gt; first and last name if there is more than one entry of the company.
gt;
gt; Can this be done (simply)? Thank you.
gt;
gt; --
gt; hgopp99
gt; --
gt; hgopp99

--

Dave Peterson