A
~Alan
XL2000 Vlookup returns #NA
on sheet1 CF16 I am using this formula =IF(DH15="","",VLOOKUP(DH15,partlist,1))
in cell DH15 I am using 35580 which is a part number from sheet named (PARTS) found in the 4th column "D"
on sheet named (parts) insert-named-defined partlist =parts!$A$2:$D$60
I need it to return charecters in column A can someone please tell me what I forgot to do since this formula is working ok in another workbook
on sheet1 CF16 I am using this formula =IF(DH15="","",VLOOKUP(DH15,partlist,1))
in cell DH15 I am using 35580 which is a part number from sheet named (PARTS) found in the 4th column "D"
on sheet named (parts) insert-named-defined partlist =parts!$A$2:$D$60
I need it to return charecters in column A can someone please tell me what I forgot to do since this formula is working ok in another workbook