I have a spreadsheet consisting of two columns, one column text and the other
values.
I want to copy a formula down an adjacent third column that will copy values
in the second column to cels in each row that is relevant to the text content
of the first column. Can you please suggest how I can achieve this?

A more clearly stated explanation of what you want to do would allow one of
us to make a helpful suggestion

"Guy Keon" wrote:

I have a spreadsheet consisting of two columns, one column text and the other
values.
I want to copy a formula down an adjacent third column that will copy values
in the second column to cels in each row that is relevant to the text content
of the first column. Can you please suggest how I can achieve this?

Guy

Who/what decides what is "relevant"?


Gord Dibben Excel MVP

On Tue, 15 Nov 2005 00:06:01 -0800, "Guy Keon" <Guy
wrote:

I have a spreadsheet consisting of two columns, one column text and the other
values.
I want to copy a formula down an adjacent third column that will copy values
in the second column to cels in each row that is relevant to the text content
of the first column. Can you please suggest how I can achieve this?