Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

2012-02-04 Thread Anoop K Dixit
Hi Sanjib, Please find attachment. Regards, Anoop On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Experts, Please See the attachment and Help me regarding VLOOKUP FUNCTION Thanking you in Advance Sanjib -- - -- FORUM RULES

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

2012-02-03 Thread The Viper
please find the attached On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Experts, Please See the attachment and Help me regarding VLOOKUP FUNCTION Thanking you in Advance Sanjib -- - -- FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

2012-02-03 Thread Venkat CV
Hi Sanjib, Look Attached... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Feb 3, 2012 at 1:28 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Experts, Please See the attachment and Help me regarding

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

2012-02-03 Thread chandra sekaran
Hi Sanjib simple Vlookup forumula to solve your Query Regards chandru chennai On Fri, Feb 3, 2012 at 4:28 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Thank you for your help ragards, sanjib On Fri, Feb 3, 2012 at 4:02 PM, The Viper viper@gmail.com wrote:

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

2012-02-03 Thread Vijayendra Rao
You can use the below formula =INDEX($H$2:$J$7,MATCH($B2,$H$2:$H$7,1),2) =INDEX($H$2:$J$7,MATCH($B2,$H$2:$H$7,1),3) Attached is the excel file for your reference. Regards, Vijayendra 2012/2/4 chandra sekaran duraichan...@gmail.com Hi Sanjib simple Vlookup forumula to solve your Query