=vlookup() returns a single value.

Maybe you could filter (data|filter|autofilter) and show the cells that begin
with B.

Tommy wrote:

Given data_array:

abc 1000
abx 2000
bcd 3000
def 4000
bhg 3200

and lookup_value is b??, how can we obtain result with

bcd 3000
bhg 3200

using VLOOKUP

thanks.

--

Dave Peterson