Vlookup returns #NA

  • Thread starter Thread starter ~Alan
  • Start date Start date
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
 
 
Hi
ig I understood your description correctly the part number is in column
D and you need to return the value from column A. If this is correct
VLOOKUP won't work as it requires the lookup value in the left most
column. Try the following formula instead:
=IF(DH15="","",INDEX('parts'!$A$2:$A$60,MATCH(DH15,'parts'!$D$2:$D$60pa
rtlist,0)))
 
Thank you for helping me solve my problem I moved column D to column A
I did not know
VLOOKUP won't work as it requires the lookup value in the left most
column   :)

Frank Kabel wrote: Hi
ig I understood your description correctly the part number is in column
D and you need to return the value from column A. If this is correct
VLOOKUP won't work as it requires the lookup value in the left most
column. Try the following formula instead:
=IF(DH15="","",INDEX('parts'!$A$2:$A$60,MATCH(DH15,'parts'!$D$2:$D$60pa
rtlist,0)))
 
Back
Top