Vlookup Date Format

[rajjana]

Dear Friends

how to use vlookup add numbers and date(without change Date Format)

[AlKey]

Try this one with TEXT function

=IFERROR(VLOOKUP(H9,$A$9:$C$13,2,0),"")&"/"&TEXT(IFERROR(VLOOKUP(H9,$A$9:$C$13,3,0),""),"m/d/yyyy")

[cbatrody]

Modify the formula in I9 as following:

=IFERROR(VLOOKUP(H9,$A$9:$C$13,2,0),"")&"/"&IFERROR(TEXT(VLOOKUP(H9,$A$9:$C$13,3,0),"dd-mm-yyyy"),"")

[Jonmo1]

You have to apply the TEXT function to the result of the 2nd vlookup so it will appear as a date.
=+IFERROR(VLOOKUP(H9,$A$9:$C$13,2,0),"")&"/"&IFERROR(TEXT(VLOOKUP(H9,$A$9:$C$13,3,0),"m/d/yyyy"),"")

Although the resulting value looks a bit wierd due to the / seperating the 2 vlookup results..