Information V lock up table

[Luis91]

is it possible to do a V lock up with out create a new colon with the function left?

[TABLE="width: 439"]
<colgroup><col width="87" style="width: 65pt;"><col width="91" style="width: 68pt;"><col width="87" span="3" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"]code [/TD]
[TD="width: 91"] amount[/TD]
[TD="width: 87"][/TD]
[TD="width: 87"] code[/TD]
[TD="width: 87"] amount[/TD]
[/TR]
[TR]
[TD]209 -cost of sales[/TD]
[TD="class: xl63, align: right"] 120,000.00 [/TD]
[TD][/TD]
[TD="align: right"]209[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

=VLOOKUP(E2&*"*,A:B,2,0)

where E2 = 209.