I have a large Excel document with worksheets for each new day. Yesterdays file updates were added in the Notes column (DZ) of that days worksheet (5.14). Today's worksheet is 5.15 and again the notes column is DZ. I'm looking for a formula that will copy the text from yesterday's notes (the text typed in) in column DZ to the notes column on todays report. Column A on both worksheets contain the identifying account info for which the notes would need to align.
Below are the formulas I have tried and the output of these:
=IF(COUNTIFS('5.14'!A:A,A2,'5.14'!DZ:DZ,"X"),"X","") but I'm not sure how to get the formula to copy the actual typed text in the cell vs just adding an "x" indicating that there is text.
=IF(COUNTIFS('5.14'!A:A,A2,'5.14'!Dz:Dz,""),"") but again it does not copy the actual text typed in on the previous day. If there is text from the previous day for this account, todays report shows "FALSE" or is blank if there was no update listed yesterday.
=VLOOKUP('5.14'!A:A,A2,'5.14'!DZ:DZ,"") but I get #VALUE ! error
I think I'm close but not sure how to get it pick up the typed text. Thanks in advance your any assistance!
Below are the formulas I have tried and the output of these:
=IF(COUNTIFS('5.14'!A:A,A2,'5.14'!DZ:DZ,"X"),"X","") but I'm not sure how to get the formula to copy the actual typed text in the cell vs just adding an "x" indicating that there is text.
=IF(COUNTIFS('5.14'!A:A,A2,'5.14'!Dz:Dz,""),"") but again it does not copy the actual text typed in on the previous day. If there is text from the previous day for this account, todays report shows "FALSE" or is blank if there was no update listed yesterday.
=VLOOKUP('5.14'!A:A,A2,'5.14'!DZ:DZ,"") but I get #VALUE ! error
I think I'm close but not sure how to get it pick up the typed text. Thanks in advance your any assistance!
