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
--
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
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
func
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,
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 Ex
