$$Excel-Macros$$ vlookup with 2 criteria

hi, does anyone have idea or solution to solve search over 2 columns range where both criteria needs to be met. e.g. if you have database with 3 columns. column A is account, column B is cost centar and column C is value. I would like to search for value of specific account for specific cost center

Re: $$Excel-Macros$$ Attendance

Hi Kantilal, You can use the formula as mentioned below :- =IF(G7<4/24,0,IF(AND(G7>4/24,G7<6/24),0.5,IF(AND(G7>6/24,G7<12/24),1,IF(G7>12/24,2,"NA" Attached is the solution for your reference. Please have a look and let me know if any further assistance is required. Best regards, Ayush Jain G

Re: $$Excel-Macros$$ Attendance

Hi I have made and sent this file earlier. Please see if you can locate this file somewhere in the 'Files' section. The name of the file should be 'tracker.xls' or 'attendance.xls' Ashish On 5/8/10, Kantilal Badale wrote: > Hi all, > > Please suggest solution for attached sheet > > Thanks > >

$$Excel-Macros$$ Attendance

Hi all, Please suggest solution for attached sheet Thanks Kantilal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Linke

Re: $$Excel-Macros$$ Re: Dear Group

http://www.ebooknetworking.com/-c-21.html just chk this link On Sat, May 8, 2010 at 4:36 AM, prabhakar thakur wrote: > Kindly send book of dot net. > > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > > > > On Wed, May 5, 2010 at 6:39 PM, prabhakar thakur < > prabhakarthak...@gmail.com

$$Excel-Macros$$ VBA Coaching Instiute In New Delhi

Hi All, Please let me know if anyone knows any VBA coaching institute in New Delhi... Thanks Deepak Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twit

$$Excel-Macros$$ Re: Dear Group

Kindly send book of dot net. Thanks, Prabhakar Thakur New Delhi +919953736776 On Wed, May 5, 2010 at 6:39 PM, prabhakar thakur wrote: > Hi Champs, > I need Urgent help. Please send .net book > > -- > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > -- --

$$Excel-Macros$$ 14 secret shortcuts of excel

Dear group members, I have added two more Shortcuts in the "Secret shortcut of excel" ebook. You can download the ebook from the link http://bit.ly/aX6x3a Please let me know if you know more such keyboard Shortcuts. I will include them in next version. Thank You. Best regards, Ayush Jain -- -

Re: $$Excel-Macros$$ Ebook on Excel 2003 VBA

http://www.tudosobrexcel.com/ o link correto 2010/5/8 Harpreet Singh Gujral > Jaao Matoso, > > The link doesnt work > > Harry > > On May 7, 2:35 am, João Matoso wrote: > > www.tudosobrexcell.com > > > > 2010/5/6 nagendra baral > > > > > > > > > > > > > Hi There > > > > > Please send some web

$$Excel-Macros$$ handling errors num 1004 in vba

Hi all ! I am struggling with an error I can't understand. Here is the code failling to be executed : 1Application.DisplayAlerts = False 2On Error Resume Next 3lien = Selection.Hyperlinks(1).Address 4Set fich = Workbooks.Open(lien) I can't unders