var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Hi: Can any one please tell me how to i create a lookup sheet. I mean every time when i open the excel file it automatically update the data into the sheet from another excel file.
Howdy. It works best to have both workbooks open when setting this up. Depending on which form of lookup you use (LOOKUP, VLOOKUP, or INDEX/MATCH), the form will vary but the reference is still valid. Here is one example using INDEX/MATCH:
Note, that the workbook reference is in square brackets.
old, slow, and confused
but at least I'm inconsistent!
(retired Excel 2003 user, 3/28/2008)
How to ask a question on forums
ok thanks only last thing which is my target workbook and which one is source
Data in the example above is the source.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors