VLOOKUP - Ref I want is imbedded in a field

[mission]

The ref I need in my vlookup is imbedded in column A i.e.,

<TABLE style="WIDTH: 282pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=376 border=0 x:str><COLGROUP><COL style="WIDTH: 144pt; mso-width-source: userset; mso-width-alt: 7021" width=192><COL style="WIDTH: 138pt; mso-width-source: userset; mso-width-alt: 6729" width=184><TBODY><TR style="HEIGHT: 11.25pt" height=15><TD class=xl16 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 144pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent" width=192 height=15>Column A:
DF7-5BB.EF9-8WW5Y
</TD><TD class=xl16 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 138pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=184 x:num>Column B:
58966544
</TD></TR></TBODY></TABLE>

As I only have DF7-5BB and looking to return what's in column B how can I ask to search using only the ref part I have?

Cheers

 

[CROY1985]

=VLOOKUP("df7-5bb*",A:B,2,FALSE)


this should do it.

 

[mission]

thanks for the suggestion - however if i have the ref in a field how would i incorporate the cell the part ref is in into =VLOOKUP("df7-5bb*",A:B,2,FALSE)?

 

[Jonmo1]

Try

=VLOOKUP(D1&"*",A:B,2,FALSE)

D1 = df7-5bb

 

[mission]

nice - cheers