Problem writing formula

[Guest]

I have a workbook with 2 worksheets. First worksheet contains columns
headed: Case, Case ID, Plaintiff ID and Plaintiff Last Name. Second
worksheet contains the same columns. In the first worksheet the Case ID and
Plaintiff ID are not populated. I would like a formula that will take the
Case and Plaintiff Last Name from the first worksheet, locate those in the
second worksheet and then pull the information for the Case ID and Plaintiff
ID from second worksheet back into the first to populate those columns. I am
new to working with formulas and apparently do not have the knowledge to
either write this formula or to know whether or not it is possible. Any help
would be greatly appreciated. I have over 30,000 rows that I have to
populate with this information. Thanks.

 

[Bob Phillips]

Case ID

=INDEX(Sheet2!B$1:B$30000,MATCH(1,($A2=Sheet2!$A$1:$A$30000)*($C2=Sheet2!$C$
1:$C$30000),0))

Plaintiff ID

=INDEX(Sheet2!C$1:C$30000,MATCH(1,($A2=Sheet2!$A$1:$A$30000)*($C2=Sheet2!$C$
1:$C$30000),0))

which are array formulae, it should be committed with Ctrl-Shift-Enter, not
just Enter, then copied down

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)