On Wed, 16 Jul 2008 01:56:29 -0700, Frank Situmorang
wrote:

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(H6 350,
'C:\hfsfile\Revenue\[NEW INVOICE LIST.xls]INVOICE
''07'!$A$7:$AX$5018,31,FALSE)),IF(ISNA(VLOOKUP(H6 350,
'C:\hfsfile\Revenue\[NEW INVOICE LIST.xls]INVOICE
''06'!$A$7:$BB$5000,31,FALSE)),IF(ISNA(VLOOKUP(H6 350,
'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

IF the referenced cell is properly referenced, my guess is that the contents of
H6350 doesn't *exactly* match anything in the range defined for any of the
tables.
--ron