Vlookup value based on a name if in one of the tables the name is split in two cells

[tanuxaxaxa]

Hi guys!

I have come across a problem

I need to vlookup a team based on the name, however in the table where I add vlookup value the whole name is put in one cell, and in the table where I vlookup value in it is split into two cells:

Table 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Value[/TD]
[TD]Name [/TD]
[TD]Team[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10$[/TD]
[TD]Maria D.[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20$[/TD]
[TD]Stefan J.[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Table 2[TABLE="width: 500"]
<tbody>[TR]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Team[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Maria[/TD]
[TD]D.[/TD]
[TD]PR[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Stefan[/TD]
[TD]J.[/TD]
[TD]RD[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Not sure how to tackle the issue and would appreciate any help!

 

[jtakw]

You're welcome.