Formatting the result of a VLookup / Custom Formatting

[Jon__Matthews]

Hi,

I am having difficulty formatting a cell which contains both text and a
VLOOKUP formulae.

I have an example of the cell below:

="Here lies the text before Vlookup "
&VLOOKUP($M$20,sheet1!$B$10:$L$1445,8,FALSE)&" Here lies follow-up
text"


The VLookup should return a date but instead is returning a string of
numbers. I'm sure there is a way of setting the format within the
formulae using dd/mm/yy somewhere. Could anyone tell me how to do this?

 

[Niek Otten]

.......&TEXT(VLOOKUP($M$20,sheet1!$B$10:$L$1445,8,FALSE),"dd/mm/yy")&.......