display cell vallue depending on the condtion

F

fazlici

Hello,
This is my problem:

I am trying to clean the records up so if (e.g.) A2=FEB 29/04
(imported form another program so therefore not formatted as a date but
as general) than I would like to have value of A1 copied to a Sheet2.

Any the help is very much appreciated,
Jas
 
G

Gord Dibben

Functions cannot copy cells, only return results.

In a cell on Sheet2.......

=IF('Sheet1'!A2="Feb 29/04",'Sheet1'!A1,"")

If you want it moved("clean the records up") you would have to use VBA to
achieve that.

Gord Dibben Excel MVP
 

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

using a cell's reference to return a value. 3
Need to lookup value in cell, dependent on value in another cell 1
Finding external cell dependents works in a Sub() but not a UDF. 2
display date of today in cell X when number >0 in cell Y 2
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule 0
Two question about Excel 2007 4
Add Cells in a row depending on Date 2
For Joey2004 et al. From OP: Re Appending Question 3

Top