C
Carolyn
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?
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?