moving text from one cell to another

M

Mrs Luke

I want a formula to move text from one cell into another cell if info from
another cell matches up.
Example: Row 3 column A has a number 1 and column C has a date of 10/1/08.
Row 5 column F has a number of 1 and column G has a date of 10/3/08.
I want the date from column G to copy into and paste over the date in column
C becauase the numbers in column A and column F match up.
If it's not possible to get this to copay into/paste over and I do it in
another cell in the same row (row3 column D for the example listed above)?
 
M

Max

.. In Row 3 column A
It's easier/shorter to describe cell references as just: In A3

Ok, down to your Q ..
here's a way using index/match to extract it into col D
In D3: =IF(ISNA(MATCH(A3,F:F,0)),"",INDEX(G:G,MATCH(A3,F:F,0)))
Format as date to taste, copy D3 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
 

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

Copy Data from One Spreadsheet to Another ?????? 5
Scrabble Value calculation for Welsh words 0
column A matches f places the value from g in column b what funct 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel VBA 1
Write formula for simple copy and paste to another cell 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top