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 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 >> > > > > -- > Sam Mathai Chacko > -- Sam Mathai Chacko -- ---------------------------------------------------------------------------------- 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
querry+ncg(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet