To copy values in a column relevant to text in an adjacent column?

G

Guest

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?
 
G

Guest

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

Gord Dibben

Guy

Who/what decides what is "relevant"?


Gord Dibben Excel MVP

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
What formula do I use to show the last cell with text in a colum 3
Excel Help to copy information from one row at a time to another sheet 1
Matching Adjacent Columns? 4
Minimum nonzero value for non-adjacent columns 9
compare cells in column to criteria, then average next column cell 2

Top