Lookup first two letters and return the most recent data

[Martin Chamberlin]

I am trying to read the first 2 letters of a word and return the most recent match from a column in another work sheet where the first 2 letters are the same.

Example:
Cell B1 in the active worksheet contains Bg23

Column F in sheet 4 has many words beginning with Bg---, the most recent is Bg4 and this is what I need to see. #VALUE is the result.

Any help appreciated, formula used -

=VLOOKUP(--LEFT(B1,2),Sheet4!$A$1:$F$200,6,0)