|Looking over your formula I'm not sure you have the syntax correct.|
=IFERROR(IF(ISNA(VLOOKUP(Hitachi!Summary[@PartNo],Hitachi!SparePartList[@SparePartParticulars],2,0)),"",VLOOKUP(Hitachi!Summary[@PartNo],Hitachi!SparePartList[@SpartPartParticulars],2,0)),"No description found")
The syntax of a Vlookup is:
=VLOOKUP( value, table, index_number, [not_exact_match] )
So your lookup value is: Hitachi!Summary[@PartNo]
The @PartNo needs to be a specific cell
and if your in the Hitachi workbook you
do not need to include the name in the formula.
Your table is: @SparePartParticulars
It should be two or more columns
and is the range of cells that contains the data your looking for.
Somthing like: B1:C20
Your index_number is: 2
The index number is the column number,
in table, from which the matching value is returned
so you are looking in the second column of your table array.
The last is you want an Exact Match, 0
So your formula should look somthing like:
=IF(ISNA(VLOOKUP(Summary!A1,SparePartList!B1:C20,2,0)),"No description found",VLOOKUP(Summary!A1,SparePartList!B1:C20,2,0))
If your first Lookup fails, it will return the "No Description found" message,
else it returns the value from the second column in your table.
Is that what your looking for?
message edited by mmcconaghy