Re: $$Excel-Macros$$ Indirect Formula - Need Advise

Thanks Noorain, sorry i had missed out your response... for the first time i'm using this Indirect formula & with Adress or other criterian... will you advise me bit more about Indirect & Adress formulas usage ??with few exmples so that i can learn in detail ??? cheers JP On Fri, Nov 11, 2011

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

Hello JP, In Summary B4, copy down & across. =LOOKUP(9E+300,INDIRECT("'"&$A4&"'!B1:"&ADDRESS(2^20,COLUMNS($A4:B4 __ HTH Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

Dear JP, Please find attached sheet, I hope it will help to u.. try.. =VLOOKUP($A2,INDIRECT($G$3&"!A:D"),MATCH(B$1,AN!$A$1:$D$1,0),0) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Indirect Formula - Need Advise

Dear Experts, To make a Summary, i'm using indirect formula and need your help & advise to complete the same.. Here with enclosed the example along with the issue. thank you. Jp -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread tit