Matching Columns, Finding IF Blank, Adding Date

[tinkdrummer]

Hello Geniuses,

I am trying to find a way, formula or VBA, to transcribe records.

Sheet1 Column A has the title of record
Sheet1 Column D has the date of the record
Sheet2 Column A has the title of record (new sheet that info needs to transcribe to)
Sheet2 Column D needs to have today's date if the Sheet1ColD is not blank

If Sheet1 cell A3 = sheet2 cell A3 AND sheet1 cell D3 is not blank, THEN sheet2 cell D3 enters today's date; if sheet1 cell D3 is blank, do nothing.
I have 500 rows to complete this on.

I am in need of some way to find if all the rows in the first sheet match the second sheet, if so, then if the first sheet has a date recorded, then the new sheet needs to have today's date.

thank you to anyone that can help.
-TD

 

[myall_blues]

In D3 on Sheet2 try:

=IFERROR(IF(Sheet1!D3="","",VLOOKUP(A3,Sheet1!$A$3:$D$503,4,FALSE)),"")

then copy it down to the remaining rows. Change the

 

[Alex Blakenburg]

The example given indicates that the rows on Sheet2 and Sheet1 line up and I think that is unlikely.
Also how do you expect it to work, if you use "Today()" in a formula then if you open the spreadsheet tomorrow then the dates will change, is that what you want to happen. If not it will need to be VBA.
Also does sheet2 Column D already have dates in it and do you only want the new items in sheet1 (ie blank date in sheet2) to be updated when you update the data in sheet1.
PS: You have 2 Excel versions listed, if you want a formula do we use a 365 formula or a pre-365 formula