I have a formula which use IF and VLOOKUP that refers to a linked worksheet and depending on the data in the linked worksheet will return a value or #N/A because the VLOOKUP value is not present in the linked worksheet.
I am trying to get the formula to return a 0 rather than N/A when the LOOKUP value is not present in the linked worksheet
=IF(A24="","0",(VLOOKUP(A24,'Y:\Steve\Planning\MSP''S\RED MRP\[RED MRPS JAN.xls]2005'!$1:$65536,27,FALSE)))*(VLOOKUP(A24,Costing,11,FALSE))
As you can see if the value A24 is not present in
'Y:\Steve\Planning\MSP''S\RED MRP\[RED MRPS JAN.xls]2005'
Then #N/A is returned and I need it to return a 0
Any help would be appreciated.
Bookmarks