Displaying the date as part of a vlookup formula

**john dalton** · 07-09-2013, 08:38 AM

I am looking to use a vlookup formula to display a string of text and a date, I can get the string of text part working but the date just display as a number rather than as 09 July 2013, Please see formula below for details.

=IF(VLOOKUP($F$4,client_list2,30,FALSE)="","",VLOOKUP($F$4,client_list2,29,FALSE)&" "&VLOOKUP($F$4,client_list2,30,FALSE)&" "&$X$4&" "&AC4)

AC4, the final part of the formula is where the date is stored.

Thanks in advance

JD

**Rambo4711** · 07-09-2013, 08:47 AM

You must use text format on the cell in your formula that contains the date:

TEXT(your date cell,"D MMMM YYYY")

**Debraj Roy** · 07-09-2013, 08:50 AM

If you other part is working fine..

then try this one..

Formula:

=IF(VLOOKUP($F$4,client_list2,30,FALSE)="","",VLOOKUP($F$4,client_list2,29,FALSE)&" "&VLOOKUP($F$4,client_list2,30,FALSE)&" "&$X$4&" "&TEXT(AC4,"dd-mm-yyyy"))

**john dalton** · 07-09-2013, 11:13 AM

That works great, is there a way to add into the formula to look at the fsecond appointment date in a list and return the date and time of that appointment and display it as part of the lookup string?

The date and time would be on another sheet and would be identifiable by the name match and apoointment no. 2