$$Excel-Macros$$ Re: Help on Vlookup

2016-07-22 Thread deepu . dubey91
Replace =vl+VLOOKUP(E2,B2:C339,2,FALSE) first of all on this point, vlookup will not work, use instead Index and match* =INDEX(B1:B339,MATCH(E2,C1:C339,0))* *Regards* *Deepu* On Friday, 17 June 2016 12:52:48 UTC+5:30, vikas khen wrote: > > Hi all, > > > > Need your help on attached excel she

$$Excel-Macros$$ Re: Help on Vlookup

2016-07-19 Thread सचिन शर्मा
Hi PFA, Regards, Sachin On Friday, June 17, 2016 at 12:52:48 PM UTC+5:30, vikas khen wrote: > > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the value. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME