sir how to vlookup formula two line break in excel. sir my code is, this code is working a

[mahesh_1981]

sir how to vlookup formula two line break in excel. sir my code is, this code is working and two line gape.
but two line distance very long, i try to short gape in two line, any help.
thank you

code :
=IF(VLOOKUP(A13,CustomerName!B:C,2,FALSE)&CHAR(10)&IF(VLOOKUP(A13,CustomerName!B:AB,27,FALSE)

Code Display:

2/34-35, GOPAL IND ESTATE, OPP PNB BANK, B/H HARSHAD CHAMBER, ODHAV, AHMEDBAD - 382415

VAT TIN No. : 24072000173 Dt.: <= two line distance long , i short gape two line

[aganesan99]

Hi mahesh_1981,

can you post the full formula, I don't think it is full

Thanks,
aganesan99