Vlookup using named range returns N/A - Help

[dab1477]

Doing something wrong...Need adjusted!

I have 2 excel sheets within the same workbook. Each contains Material # field as TEXT. Sheet 1 contains Sales data and Sheet 2 contains Inventory data. I want to do VlOOKUP on Sheet 1 in an added column to post the inventory associated with the Material # from Sheet 2. My formula looks like this:
=vlookup(a2,currentinv,4,false) where Currentinv = sheet 2 data array covering Sheet2!$a2:$e1078

I named Sheet 2 data field as CurrentInv for convenience. I have had this work in past endeavors, but can't get past #N/A error. I have verified BOTH sheets are sorted by Material # column in decending order.

I have attempted to resolve by converting MATERIAL # field to NUMBER format = unsuccessful. Still errors as #n/a

Help!

Thanks in advance.

 

[etaf]

anything like spaces in the cell
or numbers as text

if you goto
if in a new cell
you choose
=sheet1!A2 = Sheet2!cell where there is a match (or whatever you have called the sheets)
and see if that returns TRUE
then you at least know the match should be working on the first section of vlookup