$$Excel-Macros$$ Re: MATCH and INDEX function instead NESTED IF function

2016-10-31 Thread GENIUS
the same as the meaning of zero rated sales tax and exempt sales tax sorry I'm just joking, actually I downloaded this template from somewhere, they were using this, and I did not bother to ask from the person what does this mean. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

Re: $$Excel-Macros$$ MATCH and INDEX function instead NESTED IF function

2016-10-31 Thread GENIUS
I understand your formula of vlookup but would you please tell me is there any chances of using the MATCH and INDEX function, if we change the pattern of the sheet, for more please see the attachment, because vlookup seach only the data on the right but what about if the data is on the left --

$$Excel-Macros$$ Selecting multiple sheets affects selections on those sheets

2016-10-31 Thread carl.malmquist
I am using ExportAsFixedFormat() to print multiple sheets to PDF. I use Sheets(Array("sheet1","sheet2",sheet3")).select to specify the sheets. For each sheet to print, I specify the range of cells to print. I've tried selecting the ranges on each sheet before grouping the sheets. I've tried

$$Excel-Macros$$ MATCH and INDEX function instead NESTED IF function

2016-10-31 Thread Raja Kishore Patnaik
What is the difference between not pass and fail. Can you provide the details. -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accur

$$Excel-Macros$$ Forum rules : Please adhere else you will be BANNED

2016-10-31 Thread Raja Kishore Patnaik
Dear Ayush, Thanks for briefing of rules of forum. Raja Kishore Patnaik -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate t

$$Excel-Macros$$ Introduce Yourself !!

2016-10-31 Thread Raja Kishore Patnaik
Hello to All, Myself Raja Kishore Patnaik aged 40 working at Ghansoli, navimumbai as console officer for last 9yrs dealing with excel. I join this forum to upgrade myself with advance excel with VBA macros. Raja kishore Patnaik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan

Re: $$Excel-Macros$$ MATCH and INDEX function instead NESTED IF function

2016-10-31 Thread genius007_ufo via MS EXCEL AND VBA MACROS
CAN WE USED MATCH & INDEX FUNCTION IF WE CHANGE THE PATTERN OF THE SHEET , THANK YOU VERY MUCH FOR YOUR HELP From: XLS time To: excel-macros@googlegroups.com Sent: Monday, October 31, 2016 12:45 PM Subject: Re: $$Excel-Macros$$ MATCH and INDEX function instead NESTED IF function

Re: $$Excel-Macros$$ MATCH and INDEX function instead NESTED IF function

2016-10-31 Thread XLS time
I used, Vlookup with lookup -- On Mon, Oct 31, 2016 at 9:56 AM, Izhar wrote: > > can anyone used MATCH and INDEX function instead of nested if function in > the attachment, the answer is there but i want to use MATCH and INDEX > function instead nested if function, if there is any possibility,