• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup not working

Hi All,

I came up with a new chaleenge (at least for me) i.e. vlookup not working.
actually whenever i write syntax =vlookup(lookupvalue,table array=anotherworkbook,.......)
then another workbook array/range does not get selected.
file structure are as below :
may or may not be shared
may or may not be on local server
may or may not be on same system

please help me out of this it takes a lot of time for copying a data from another workbook to this workbook
also i have noticed that i could not get copy format as well.
what are the reasons of all this and how could i came up with this.

Regards,
 
thanks for your tip wudixin but I have 2010 what should I do.
it consume my lots of time for copying a data from another workbook to this workbook and then applying vlookup or other functions as well
 
In continuation to what Wudixin says, when you open two excel files as two separate instances, generally, some of the functions/formula do not work as expected in 2007 or greater versions.

As suggested by Wudixin, you need to open the referenced workbook from the existing workbook from open menu, so that the instance of excel will remain same.

Regards,
Prasad DN
 
Back
Top