Try
=VLOOKUP(A2,MAP,3,0)

--
Jacob (MVP - Excel)


"Lbengston" wrote:

Vlookup appears to resolve per the funcion arguements display but does not
return value to the cell on the worksheet.
=VLOOKUP(A2,MAP,3)
MAP is a named range on another worksheet in the same workbook. Matching
values are text fields containing numbers )e.g. A1=41000-010-100, resoved
result is 41000).