Vlookup with split within Cells

[Nandakumar]

Hi,

i had attached worksheet,where i require a formula with vlookup which contains break in a organised within a cell.

Mentioned in the sheet,how output formula should be.

Let me know any questions.

Request you to please help!

 

[Syedali]

Hi,

i had attached worksheet,where i require a formula with vlookup which contains break in a organised within a cell.

Mentioned in the sheet,how output formula should be.

Let me know any questions.

Request you to please help!

PFA

Click Like if you really like it..

 

[bosco_yip]

In C3, enter :

=IF(A3="","",IFERROR("Employee ID : "&A3&CHAR(10)&"Employee Name : "&VLOOKUP(A3,Data!$B$2:$D$4,2,0)&CHAR(10)&"Amount : "&VLOOKUP(A3,Data!$B$2:$D$4,3,0),""))

then, click Format cells >> select Alignment tag, check the box of "Wrap text"

Copy down formula.

Regards

 

[Nandakumar]

Thank you so much It works

In C3, enter :

=IF(A3="","",IFERROR("Employee ID : "&A3&CHAR(10)&"Employee Name : "&VLOOKUP(A3,Data!$B$2:$D$4,2,0)&CHAR(10)&"Amount : "&VLOOKUP(A3,Data!$B$2:$D$4,3,0),""))

then, click Format cells >> select Alignment tag, check the box of "Wrap text"

Copy down formula.

Regards[/quo