On Thu, 17 Jul 2008 20:48:02 -0700, Frank Situmorang
wrote:

Yes Ron...the destination workbook is xlsb ang the source workbook is xls.
Can it still be working even though different type?

The other one Ron, my problem now in this vlookup formula in the source date
column it the date is nothing/blank, but in the destination workbook it shows
" 0-Jan-00".

How can I make it to be the same...(looked blank), the date "0-Jan-00"
doesnot mean anything, and I am affraid if I make the formula sum if
zerro,......it will effect the result)

Thanks for your help.


--
H. Frank Situmorang

Sorry for the delay in responding, Frank. For some reason, this message of
yours did not appear on my usual computer. I'm on a different computer (in a
different location) and today is the first I've seen it.

In any event, I would have thought that if a function can work on a closed
workbook, it shouldn't matter if it was a different "type" of Excel workbook.
But I'll have to do some experimentation.

So far as your VLOOKUP returning a 0 when the original is blank: I'm not sure
I understand what you are trying to do, or not do, and how it relates to your
comment "make the formula sum if zerro"
--ron