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

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$$ MATCH and INDEX function instead NESTED IF function

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,

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

CAN WE USED MATCH & INDEX FUNCTION IF WE CHANGE THE PATTERN OF THE SHEET , THANK YOU VERY MUCH FOR YOUR HELP From: XLS time <xlst...@gmail.com> To: excel-macros@googlegroups.com Sent: Monday, October 31, 2016 12:45 PM Subject: Re: $$Excel-Macros$$ MATCH and INDEX functi

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

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

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

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, would you please do it thanks in advance -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in