Thanks to all of you, Ron and Jarek. In fact the problem is that the source
sheet and the destination sheet are different, one in binary and one in
nomral excel.

Thanks very much
--
H. Frank Situmorang


"Ron Rosenfeld" wrote:

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