Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

Thanks AshishI was making mistake while freezing the cells. Thanks for the support. Regards, Pooja On 21 Mar 2016 19:58, "Ashish Koul" wrote: > see attachment > > On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma > wrote: > >> Hi Ashish, >> >>

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

see attachment On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma wrote: > Hi Ashish, > > This is not working.It is giving 0 value. > > Regards, > Pooja Sharma > On 21 Mar 2016 19:30, "Ashish Koul" wrote: > >>

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

Hi Ashish, This is not working.It is giving 0 value. Regards, Pooja Sharma On 21 Mar 2016 19:30, "Ashish Koul" wrote: > =VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0) > > On Mon, Mar 21, 2016 at 7:27 PM, Pooja Sharma > wrote: > >> Hi All,

Re: $$Excel-Macros$$ query on usage of Vlookup and Hlookup together

=VLOOKUP($A16,$A$2:$H$10,MATCH(B$15,$A$2:$H$2,0),0) On Mon, Mar 21, 2016 at 7:27 PM, Pooja Sharma wrote: > Hi All, > > Hi All, > > I have a query, if there is any possibility to apply Vlookup and Hlookup > together to achieve results as required in the attached sheet. >

$$Excel-Macros$$ query on usage of Vlookup and Hlookup together

Hi All, Hi All, I have a query, if there is any possibility to apply Vlookup and Hlookup together to achieve results as required in the attached sheet. Regards, Pooja Sharma -- 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