Re: $$Excel-Macros$$ vlookup and index/match functions help required

thanks kris sir and sam sir . On Tue, Feb 7, 2012 at 10:30 PM, Sam Mathai Chacko wrote: > I would also go with the LOOKUP suggested by Kris as it is direct, and > simple. But if you do not want to make any change to your layout, you could > also use a CSE formula > > =INDEX($H$3:$H$9,MATCH(B2,--T

Re: $$Excel-Macros$$ vlookup and index/match functions help required

I would also go with the LOOKUP suggested by Kris as it is direct, and simple. But if you do not want to make any change to your layout, you could also use a CSE formula =INDEX($H$3:$H$9,MATCH(B2,--TRIM(RIGHT(SUBSTITUTE($G$3:$G$9,"-",REPT(" ",20)),10)),-1)) Regards, Sam Mathai Chacko On Tue, Fe

Re: $$Excel-Macros$$ vlookup and index/match functions help required

Hi, In C2 and copied down, =LOOKUP(B2,$I$3:$J$11) and arrange your table like RANGE GRADE 0 No Grade 3.2 D 4.1 C2 5.1 C1 6.1 B2 7.1 B1 8.1 A2 9.1 A1 10.1 No Grade Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ vlookup and index/match functions help required

thanx for help but its giving #na on entering 3.2 in any cell in bucket 3.2 to 4 range 4.1 to 5 range 5.1 to 6 range 6.1 to 7 range On Tue, Feb 7, 2012 at 8:39 PM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Sort the data and use it.. > > =LOOKUP(B3&"*",$G$3:$G$9,$H$3:$H$9) > > See attached s

Re: $$Excel-Macros$$ vlookup and index/match functions help required

Dear Sourabh, Sort the data and use it.. =LOOKUP(B3&"*",$G$3:$G$9,$H$3:$H$9) See attached sheet.. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Tue, Feb 7, 2012 at 8:05 PM, Sourabh Salgotra wrot

Re: $$Excel-Macros$$ vlookup and index/match functions help required

Hi Sourabh, Find the attached file. I have used only VLOOKUP to achieve your requirement. I hope this clarify clear. Regards, MARIES. On Tue, Feb 7, 2012 at 6:35 PM, Sourabh Salgotra wrote: > > dear sir, > plz help me in attached file. > > > Thanks & Regards > Sourabh > Contact Numb