Dear friends,
Suppose i have two workbooks named w1 and w2. I want to create a formula that
looks into these workbooks and gives me the right answer into my third workbook
w3 as long as those two workbooks are opened.
Suppose that columns in w3 have the following information:
column A Column B
John 30
Joseph 18
Maria 50
Diasy ?
how can i write my formula in w3 column B to get the answers as in column B if
the first two names are from w1 and the last 2 names are from w2?
currently i am using the formula below to give the information from w1 only but
i want to do it at once in one formula for both the workbooks? My w1 was saved
as w1.21-01-2011
=IFERROR(VLOOKUP($A1,INDIRECT("'["&&q uot;w1."&IF(DAY(I$3)<10,"0"&
;DAY(I$3),DAY(I$3))&"-"&IF(MONTH(I$3)<10,"0"&MO
NTH(I$3),MONTH(I$3))&"-"&YEAR(I$3)&".xls"&" ;]"&"Sheet1"&"'!$A:$Q&
quot;),2,FALSE),"-")
i hope my question is clear and waiting your usual replies
kindest regards,
John
________________________________
This e-mail message and any attachment hereto are confidential information
intended for a specific addressee and purpose. If you are not the intended
recipient, or a person responsible for delivering it to the intended recipient,
you may not disclose, copy, distribute or take any action based on the contents
hereof, or retaining this message or any part of it, in any form whatsoever.
Any such conduct is prohibited and may be unlawful. If you have received this
e-mail in error, please notify the sender immediately by replying to this
message and destroy all copies hereof. No opinion expressed by the sender
necessarily constitutes the opinion of Mobile Telecommunications Ltd (MTC).
This message does not constitute a guarantee or proof of the facts mentioned
herein. No employee or intermediary is authorized to conclude a binding
agreement on behalf of MTC by e-mail without the express written confirmation
by a duly authorized representative of MTC. All reasonable precautions have
been taken to ensure a virus free message however, MTC cannot guarantee this
nor accept responsibility whatsoever for loss or damage arising from the use of
this e-mail or attachments. MTC reserve the right to monitor all e-mail
communications transmitted through our network.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
