Hi Noorian,
One option is to format the reference cell (with the date in it) as text, then
type in the date again, exactly as it appears on the appropriate sheet tab. You
also need to add single quotes around the sheet name, so the indirect function
looks like this:
INDIRECT("'"&B6&"'!A:B") Without the single quotes, I think Excel reads the
dash as a subtraction sign.
I've attached your sheet with these modifications.
As to your question regarding case-sensitive VLOOKUP, I have given a slightly
shorter, non-array alternative using LOOKUP for you to have a look at.
Regards - Dave
Date: Fri, 14 Jan 2011 01:53:41 -0800 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Hi Dave, How can solve it. Please give ur valauble suggestion.. Thanks, Noorain Ansari On Fri, Jan 14, 2011 at 1:34 AM, Dave Bonallack <davebonall...@hotmail.com> wrote: Hi, The problem is not the sheet names, but the indirect refering to a date, which is really just a date code, not a date as displayed. Regards - Dave. Date: Thu, 13 Jan 2011 23:08:24 -0800 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com CC: koul.ash...@gmail.com Dear Ashish, I am unable to find data through Vlookup+indirect when sheet name is Date wise like 14-Jan,15-Jan,16-Jan..... Please see attached sheet.. -- Thanks & regards, Noorain Ansari On Thu, Jan 13, 2011 at 9:49 PM, ashish koul <koul.ash...@gmail.com> wrote: hi 1 case sensitive lookup using index and match 2 vlookup & indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . <ms.exl.lear...@gmail.com> wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. ----------------------- Ms.Exl.Learner ----------------------- -- ---------------------------------------------------------------------------------- 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 -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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 -- ---------------------------------------------------------------------------------- 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 -- ---------------------------------------------------------------------------------- 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 -- Thanks & regards, Noorain Ansari -- ---------------------------------------------------------------------------------- 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 -- ---------------------------------------------------------------------------------- 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
sample(Query)(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
