Lookup on Part of Lookup Array

Hi

Assuming 1st row is a header row

Sheet1, Column A

1230000_XL07 - WB OPS
1230001_XL08 - WB OPS
1230002_XL09 - WB OPS


Sheet 2, Column A

1230000

How do I lookup 1230000 and return 1230000_XL -07 WB OPS in B2

TIA

Perhaps:

Sheet2!B2:
=VLOOKUP($A2&"*",Sheet1!$A:$A,1,0)

EDIT:

if A2 will always be followed by _ then you could alter slightly to make a little more watertight given use of * (wildcard), ie:

=VLOOKUP($A2&"_*",Sheet1!$A:$A,1,0)