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 > > > > > > > > > > -- > - >

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 > Hi Sanjib > simple Vlookup forumula to solve your Query > > Regards > chandru >

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 wrote: > >> please find

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 * 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 regar

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+ m