Re: $$Excel-Macros$$ Multipal sheet vlookup-Urgent plz

Thank you. You are great!! Thanks again. On Thu, Mar 8, 2012 at 9:09 AM, NOORAIN ANSARI wrote: > Dear Vinod, > > Please use.. > > =VLOOKUP($F15,INDIRECT($K$15&"!F:I"),3,0) > > and see attached sheet.. > > -- > Thanks & regards, > Noorain Ansari > *http://noorainansari.com/* > *http://excelmacro

Re: $$Excel-Macros$$ Multipal sheet vlookup-Urgent plz

Dear Vinod, Please use.. =VLOOKUP($F15,INDIRECT($K$15&"!F:I"),3,0) and see attached sheet.. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Wed, Mar 7, 2012 at 11:42 PM, vinod rao wrote: > HI T

$$Excel-Macros$$ Multipal sheet vlookup-Urgent plz

HI Team, I need to put a vlookup for multipal sheet and get result on one sheet. Based on the sheet selection in cell hc6 the formula should get result as shown in the attached sheet. Regards, Vin -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titl