Re: $$Excel-Macros$$ return value with two look ups

thanks it is working.. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Do

Re: $$Excel-Macros$$ return value with two look ups

$$ return value with two look ups Hi Sam Thanks for the solution but I want something different. Please see my attached file, which give you more idea regarding my query -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ return value with two look ups

Hi Sam Thanks for the solution but I want something different. Please see my attached file, which give you more idea regarding my query -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need H

Re: $$Excel-Macros$$ return value with two look ups

=INDEX(OFFSET('dia 28 en8 bgt'!$A$1:$A$15,0,MATCH(summary!$B$1,'dia 28 en8 bgt'!$A$1:$J$1,0)-1),MATCH(9E+300,OFFSET('dia 28 en8 bgt'!$A$1:$A$15,0,MATCH(summary!$B$1,'dia 28 en8 bgt'!$A$1:$J$1,0)-1),1)) Regards, Sam Mathai Chacko On Tue, Jan 24, 2012 at 4:56 PM, hemal shah wrote: > hi > all mast