I have two worksheets, both with text data, not numeric data. I want to tell
Excel to look at cell C2 on worksheet 1, find that matching text in column C
on worksheet 2, and pull the text in column A of that same row to cell A1 of
worksheet 1. Then I'd repeat that formula for all of worksheet 1, until all
of column A is filled with the data from worksheet 2. I can't just copy and
paste all of column A from worksheet 2, because a lot of the entries in
column C don't appear on worksheet 1.

I don't know if this is considered consolidating or what - all the
consolidate tips seem to be about numbers. What command am I looking for?

One possible way


=INDEX('Worksheet 2'!A2:$C$200,MATCH(C2,'Worksheet 2'!C2:$C$200,0),1)

--


Regards,


Peo Sjoblom


"Carolyn" wrote in message
...
I have two worksheets, both with text data, not numeric data. I want to
tell
Excel to look at cell C2 on worksheet 1, find that matching text in column
C
on worksheet 2, and pull the text in column A of that same row to cell A1
of
worksheet 1. Then I'd repeat that formula for all of worksheet 1, until
all
of column A is filled with the data from worksheet 2. I can't just copy
and
paste all of column A from worksheet 2, because a lot of the entries in
column C don't appear on worksheet 1.

I don't know if this is considered consolidating or what - all the
consolidate tips seem to be about numbers. What command am I looking for?