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

2012-03-08 Thread vinod rao
Thank you. You are great!! Thanks again. On Thu, Mar 8, 2012 at 9:09 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Vinod, Please use.. =VLOOKUP($F15,INDIRECT($K$15!F:I),3,0) and see attached sheet.. -- Thanks regards, Noorain Ansari *http://noorainansari.com/*

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

2012-03-07 Thread vinod rao
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

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

2012-03-07 Thread NOORAIN ANSARI
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/*http://excelmacroworld.blogspot.com/ On Wed, Mar 7, 2012 at 11:42 PM, vinod rao