Re: $$Excel-Macros$$ Vlookup problem

Share your workbook plz Thanks & regards, www.MrExcel4U.com On Thu, Mar 6, 2014 at 3:55 PM, Dileep Kumar wrote: > Hi Manish, > > Will you please elobrate with example data. > > > On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal > wrote: > >> >> using vlookup an

Re: $$Excel-Macros$$ Vlookup problem

Hi Manish, Will you please elobrate with example data. On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal wrote: > > using vlookup and requirement is pick data from other sheet. > I have data in 10 column and first column is unique column.i want pick > only limited column like 4 6 9 column.and requ

$$Excel-Macros$$ Vlookup problem

using vlookup and requirement is pick data from other sheet. I have data in 10 column and first column is unique column.i want pick only limited column like 4 6 9 column.and requirement is only one time use vlookup formula and pick all data in other sheet by unique column. -- Are you =EXP(E:RT

$$Excel-Macros$$ vlookup problem

Hi , I hope this will help u =INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1) And see the attach file Priti verma -- -- 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,

$$Excel-Macros$$ vlookup problem

Hi I hope this formula will help u =INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1) And see the attach file. Priti -- -- 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, C

Re: $$Excel-Macros$$ Vlookup Problem

Thank you so much for providing such a nice solution. Thanks again ALL. On Tue, Jul 17, 2012 at 12:07 AM, Bé Trần Văn wrote: > Do as you like. > > > > 2012/7/17 Venkatesh Narla > >> Hi, >> Please find the attachment and let me know.. any thing els need.. >> >> >> Thanks, >> Venkatesh. >> >> >> O

Re: $$Excel-Macros$$ Vlookup Problem

Do as you like. 2012/7/17 Venkatesh Narla > Hi, > Please find the attachment and let me know.. any thing els need.. > > > Thanks, > Venkatesh. > > > On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay > wrote: > > Hi Friends, > > > > Please solve my VLookup Query. > > Description is given in atta

Re: $$Excel-Macros$$ Vlookup Problem

Hi, Please find the attachment and let me know.. any thing els need.. Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote: > Hi Friends, > > Please solve my VLookup Query. > Description is given in attached file. > Thanks. > > -- > With regards, > > MaNgEsH > > -- > FORUM R

Re: $$Excel-Macros$$ Vlookup Problem

Hi Mangesh, If you want to learn how vlookup works may be below links helps you.. http://www.free-training-tutorial.com/function-vlookup.html http://spreadsheets.about.com/od/excelfunctions/ss/90320vlookup.htm Regards, Lalit Mohan On Mon, Jul 16, 2012 at 5:27 PM, Mangesh Vimay wrote: > Its r

Re: $$Excel-Macros$$ Vlookup Problem

Its really helpful. U have done full R & D here. Thanks lot. On Mon, Jul 16, 2012 at 5:03 PM, NOORAIN ANSARI wrote: > Dear Mangesh, > > You can also use.. > > *=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)* > > or > > *=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))* >

Re: $$Excel-Macros$$ Vlookup Problem

Dear Mangesh, You can also use.. *=LOOKUP(9E+300,1/(($B$2:$B$6=F3)*($C$2:$C$6=G3)),$A$2:$A$6)* or *=INDEX($A$2:$A$6,MATCH(1,(($B$2:$B$6=F3)*($C$2:$C$6=$G3)),0))* or *=OFFSET($A$1,MATCH(1,(($B$2:$B$6=$F3)*($C$2:$C$6=$G3)),0),0)* with ctrl+shift+Enter See attached sheet. -- Thanks & regard

Re: $$Excel-Macros$$ Vlookup Problem

so much On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay wrote: > Thank you much Suman > > > On Mon, Jul 16, 2012 at 4:48 PM, Suman wrote: > >> Dear Mangesh, >> Please find the attached file as I have learnt this one form Noorain sir >> in this group. >> >> On Mon, Jul 16, 2012 at 4:33 PM, Mangesh

Re: $$Excel-Macros$$ Vlookup Problem

Thank you much Suman On Mon, Jul 16, 2012 at 4:48 PM, Suman wrote: > Dear Mangesh, > Please find the attached file as I have learnt this one form Noorain sir > in this group. > > On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote: > >> Hi Friends, >> >> Please solve my VLookup Query. >> Descri

$$Excel-Macros$$ Vlookup Problem

Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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, Cod

Re: $$Excel-Macros$$ VLookup Problem

=OFFSET($D$1,MATCH(K2,TIME(HOUR($B$2:$B$10),MINUTE($B$2:$B$10),SECOND($B$2:$B$10)),0),0) With ctrl+shift+enter On Tue, Jan 31, 2012 at 11:24 AM, NOORAIN ANSARI wrote: > Dear Pravesh, > > Please use..this one..see attached sheet.. > > > =INDEX($D$2:$D$10,MATCH(K2,TIME(HOUR($B$2:$B$10),MINUTE($B$2:

Re: $$Excel-Macros$$ VLookup Problem

Dear Pravesh, Please use..this one..see attached sheet.. =INDEX($D$2:$D$10,MATCH(K2,TIME(HOUR($B$2:$B$10),MINUTE($B$2:$B$10),SECOND($B$2:$B$10)),0)) with ctrl+shift+Enter -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://n

$$Excel-Macros$$ VLookup Problem

Hi Group, I am unable to extract AHT Column data through Vlookup. Please sove my query.. Thanks in Advance With Regards, Pravesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

can you send the sample sheet On Fri, Oct 15, 2010 at 3:32 AM, renuka chari wrote: > thanks for your valuble replay > but i dont need countif function > i need vlookup function to maping secound duplicate values only i am > giving small data only so we are easily find duplicate values > but data

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

thanks for your valuble replay but i dont need countif function i need vlookup function to maping secound duplicate values only i am giving small data only so we are easily find duplicate values but data in large no of lines then what? On Oct 14, 9:06 pm, ashish koul wrote: > hi > check the att

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

Dear Use sumif formulas SUMIF(Sheet1!$A$2:$A$19,Sheet2!A2,Sheet1!$B$2:$B$19) CR-MSP-619+ 110 CR-MSP-620 600 CR-MSP-621 400 CR-MSP-622 180 CR-MSP-623 140 CR-MSP-624+ 110 CR-MSP-625 150 CR-MSP-626 350 CR-MSP-627+ 80 CR-MSP-628 360 CR-MSP-629 1000 CR-MSP-630 80 CR-MSP-631+ 140 CR-MSP-63

Re: $$Excel-Macros$$ VLOOKUP PROBLEM

hi check the attachment see if it helps you you can apply customer filter on temp column and choose greater than 1 and copy all and paste into sheet2 On Thu, Oct 14, 2010 at 8:06 PM, renuka chari wrote: > GOOD EVENIG ALL EXPERTS > CAN U SLOVE MY VLOOKUP PROBLEM > > THIS IS MY DATA IN SHEET1 >

$$Excel-Macros$$ VLOOKUP PROBLEM

GOOD EVENIG ALL EXPERTS CAN U SLOVE MY VLOOKUP PROBLEM THIS IS MY DATA IN SHEET1 = VNo CR Amt = CR-MSP-619+ 70 CR-MSP-620 600 CR-MSP-621 400 CR-MSP-622 180 CR-MSP-623 140 CR-MSP-624+ 60 CR-MSP-625 150 CR-MSP-626