Hello,

Since we used Office 2007, there are many complaint of instablility of this
software.

This is my problem, I have checked that the referenced cell does Exits for
Date, but it says NA in the destatination worksheet. Here is my formula in
the cell:

=IF(ISNA(VLOOKUP(H6350, 'C:\hfsfile\Revenue\[NEW INVOICE LIST.xls]INVOICE
''08'!$A$7:$AX$6000,32,FALSE)),IF(ISNA(VLOOKUP(H63 50,
'C:\hfsfile\Revenue\[NEW INVOICE LIST.xls]INVOICE
''07'!$A$7:$AX$5018,31,FALSE)),IF(ISNA(VLOOKUP(H63 50,
'C:\hfsfile\Revenue\[NEW INVOICE LIST.xls]INVOICE
''06'!$A$7:$BB$5000,31,FALSE)),IF(ISNA(VLOOKUP(H63 50,
'C:\hfsfile\Revenue\[NEW INVOICE LIST.xls]INVOICE
''05'!$A$6:$AY$5000,29,FALSE)),VLOOKUP(H6350, 'C:\hfsfile\Revenue\[NEW
INVOICE LIST.xls]INVOICE ''07'!$A$7:$BB$5018,31,FALSE),VLOOKUP(H6350,
'C:\hfsfile\Revenue\[NEW INVOICE LIST.xls]INVOICE
''05'!$A$6:$AZ$5000,29,FALSE)),VLOOKUP(H6350, 'C:\hfsfile\Revenue\[NEW
INVOICE LIST.xls]INVOICE ''06'!$A$7:$BA$5000,31,FALSE)),VLOOKUP(H6350,
'C:\hfsfile\Revenue\[NEW INVOICE LIST.xls]INVOICE
''07'!$A$7:$AX$5018,31,FALSE)),VLOOKUP(H6350, 'C:\hfsfile\Revenue\[NEW
INVOICE LIST.xls]INVOICE ''08'!$A$7:$AX$6000,32,FALSE))

Pls help us what is wrongf in the formula

Thanks in addvance
--
H. Frank Situmorang