ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP (https://www.excelbanter.com/excel-worksheet-functions/263637-vlookup.html)

Lbengston

VLOOKUP

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).

Jacob Skaria

VLOOKUP

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).

All times are GMT +1. The time now is 10:24 AM.