Thanks sam, a simple formula works. thanks again..... Nemi On Oct 20, 7:18 pm, Sam Mathai Chacko <samde...@gmail.com> wrote: > Formula =OFFSET(INDEX($H$1:$H$105,MATCH($A2,$H$1:$H$105,0)),$B2,$C2) > > On Thu, Oct 20, 2011 at 4:13 PM, Sam Mathai Chacko <samde...@gmail.com>wrote: > > > > > > > > > > > Don't think we need an array for that. Here's a simple formula that will > > look from all the 7 tables without an array formula. > > > Regards, > > > Sam Mathai Chack (GL) > > > On Thu, Oct 20, 2011 at 2:18 PM, dguillett1 <dguille...@gmail.com>wrote: > > >> Please see my corrected macro solution? > > >> Don Guillett > >> SalesAid Software > >> dguille...@gmail.com > > >> *From:* Nemi Gandhi <nemigan...@gmail.com> > >> *Sent:* Thursday, October 20, 2011 1:51 AM > >> *To:* excel-macros@googlegroups.com > >> *Subject:* $$Excel-Macros$$ querry > > >> Thanks Ashishbhai and Noorainbhai, but i made little mistake in asking > >> query and is posted agains. The result i want is if A2=surya or chandra or > >> mangal or budh or guru or shukra or shani, look for value in appropriate > >> table and get result. > > >> -- > >> Nemi Gandhi > >> 98204 92963 > > >> -- > > >> ---------------------------------------------------------------------------------- > >> 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 athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks athttp://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 > > > -- > > Sam Mathai Chacko > > -- > Sam Mathai Chacko > > querry+ncg(Solved).xlsx > 19KViewDownload
-- ---------------------------------------------------------------------------------- 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
