$$Excel-Macros$$ Vlookup function using with match columns

2013-07-10 Thread Muralidhar E
Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup).

Re: $$Excel-Macros$$ Simple formula required

2013-07-10 Thread Anil Kumar
From: amar takale amartak...@gmail.com To: excel-macros@googlegroups.com Sent: Tuesday, 4 September 2012 2:01 PM Subject: $$Excel-Macros$$ Simple formula required -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel  

Fwd: $$Excel-Macros$$ Vlookup function using with match columns

2013-07-10 Thread Muralidhar E
Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup).

Re: $$Excel-Macros$$ Simple formula required

2013-07-10 Thread Prafull Jadhav
Dear Amar, find the same with easy...by using mid function. Regards Prafull On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar kumarmaury...@yahoo.com wrote: -- *From:* amar takale amartak...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, 4 September

Re: $$Excel-Macros$$ Vlookup function using with match columns

2013-07-10 Thread Prafull Jadhav
Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E emuralidha...@gmail.comwrote: Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with

Re: $$Excel-Macros$$ Error in output

2013-07-10 Thread sandeep shivpujan singh
Hi, The empty value is because you have not given any criteria when the match is not found. For Example : Use this : =IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),Not Found,C1) Currently none of the values which you have in Column C are present in Column E Regards, Sandeep On Wednesday, 10 July

Re: $$Excel-Macros$$ Vlookup function using with match columns

2013-07-10 Thread Muralidhar E
Hi, Dear friends, Thank u With the same i want to know using column columns *2.This is using columns or column function* =vlookup(lookup_value, Table array,*columns or column(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result

Re: $$Excel-Macros$$ Vlookup function using with match columns

2013-07-10 Thread Prafull Jadhav
Dear Murli, You can just give ref of column,,, for example if you want B column then put (B:B). =VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0) On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E emuralidha...@gmail.comwrote: Hi, Dear friends, Thank u With the same i want to know using column

$$Excel-Macros$$ Re: Repost: Excel initiating export from Crystal report

2013-07-10 Thread sandeep shivpujan singh
Probably its too latestillI was searching for some code related to Crystal Report and found your post. :) This code might help ( you need to set reference to Crystal Reports ActiveX designer Design and Runtime Library 11.0 or above) Sub CrystalRPTtoXLS() On Error GoTo ERRMSG Dim Appl

$$Excel-Macros$$ Copy value from Object

2013-07-10 Thread Sant Ram
Hi, I need help urgently how to copy value from an object (i have copy objects from web page) Thanks in advance -- Regards, Santy -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Copy value from Object

2013-07-10 Thread Basole
See if that is what needs: http://www.homeandlearn.co.uk/excel2007/excel2007s8p4.html Em quarta-feira, 10 de julho de 2013 09h51min06s UTC-3, Santy escreveu: Hi, I need help urgently how to copy value from an object (i have copy objects from web page) Thanks in advance --

Re: $$Excel-Macros$$ Copy value from Object

2013-07-10 Thread ashish koul
try this Sub Loopobjects() Dim OleObj As OLEObject Dim sel_d, val_s Dim Arr Dim ArrMatch Dim lngSelected As Long For Each OleObj In Sheet1.OLEObjects If OleObj.progID = Forms.HTML:Text.1 Then Sheets(1).Cells(OleObj.TopLeftCell.Row, 12) =

Re: $$Excel-Macros$$ Simple formula required

2013-07-10 Thread ashish koul
=TRIM(RIGHT(D3,LEN(D3)-FIND(),D3))) Regards Ashish Koul On Wed, Jul 10, 2013 at 4:20 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Amar, find the same with easy...by using mid function. Regards Prafull On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar kumarmaury...@yahoo.comwrote:

Re: $$Excel-Macros$$ Copy value from Object

2013-07-10 Thread Santy
Dear Ashish/Basole, Thanks for quick response; I really appreciate your efforts, I think how to copy web page to excel ( I tried via “Get External data from web” excel option but unable to fetch ActiveX control) Basically I want go to web page then select all value (using ctrl +a) then

Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.

2013-07-10 Thread De Premor
Why didn't you write your own code, i was send enoughsample code for create that, i think this is the time for you to find your own fish. Rgds, [dp] Pada 11/07/2013 12:08, Pravin Gunjal menulis: Dear Premor, Before save code is working fine and creating a backup, if you arrange the same