Specific Formatting from Sheet to Sheet

[psulions83]

Hi All,

I have been searching for a solution for this and have not found anything. There may be something out there and I didn't search for the correct thing.

The below formula stacks the two dates on Sheet 1.

=TEXT(IF(D6="Y",F6-60,"N/A"),"mm/dd/yyyy")&CHAR(10)&(IF(D6="Y",IF(OR(MONTH(F6)=1,MONTH(F6)=2,MONTH(F6)=3),"4/30/"&YEAR(F6),
IF(OR(MONTH(F6)=4,MONTH(F6)=5,MONTH(F6)=6),"7/31/"&YEAR(F6),
IF(OR(MONTH(F6)=7,MONTH(F6)=8,MONTH(F6)=9),"10/31/"&YEAR(F6),
IF(OR(MONTH(F6)=10,MONTH(F6)=11,MONTH(F6)=12),"1/31/"&YEAR(F6)+1)))),"N/A"))

Results on Sheet 1 -
05/02/2023
10/31/2023

On Sheet 2 I am looking that value up and it does not format them in the same manner that it does.

Results on Sheet 2 using the following formula - =VLOOKUP(A5,'Sheet 1'!A:Y,25,0)

Any help would be greatly appreciated.

 

[Fluff]

Make sure that Wrap Text is turned on for that cell.

 

[psulions83]

Wow that was simple and a silly oversight on my part. Thanks for the reply!

 

[Fluff]

You're welcome & thanks for the feedback.