how to vlookup of one cell by starting 2 digits of another cell?

Uday · Feb 10, 2010

how to vlookup of one cell by starting 2 digits of number in another cell?

Fred Smith · Feb 10, 2010

Something like:
=vlookup(left(a1,2),B:G,2,false)

Regards,
Fred