$$Excel-Macros$$ Query on lookup with more than 1 lookup values

-- Hi All, I am trying to apply lookup in 2 dimensions wherein I have to get the value as per 2 lookup values (1 is there in the row and another in the column). I am attaching the workbook in which I am looking for the desired result. Please let me know if someone can help on this. [image:

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" <koul.ash...@gmail.com> wrote: > see attachment > > On Mon, Mar 21, 2016 at 7:54 PM, Pooja Sharma <vatspoojav...@gmail.

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" <koul.ash...@gmail.com> 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 <vatspoojav...@gma

$$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

Re: $$Excel-Macros$$ how to insert Excel File in powerpoint presentation...

/groups/opt_out. -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * -- 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

Re: $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST

Hi Priti and Ashish! Thanks a lot for your. -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * On Sat, Jul 7, 2012 at 7:10 PM, priti_verma pritiverma1...@gmail.comwrote: *Please see the attached file* * * *Good

$$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST

Hi All, Is there any way in excel, that we can make a standard spreadsheet, to convert time from IST to BST and BST to IST for Regular and Daylight Saving Time as well. Waiting for experts solution. -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything

$$Excel-Macros$$ I want to learn VBA

Hi All, I want to learn VBA, therefore, could anybody suggest with a good link where I can learn it. -- *Best Regards Pooja Sharma* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ pdf. to Excel

Hi All, I have a query regarding .pdf to excel. Is there any way that, I can transfer the files that are in .pdf format into excel?? -- Best Regards Pooja Sharma -- -- Some important links for excel users: 1

$$Excel-Macros$$ help on .pdf to excel

Hi All the Champs, I've a query, is there any way to convert a .pdf file into an excel format?? If there is any way, the please guide the way.. -- Best Regards Pooja Sharma -- -- Some important links for excel

Re: $$Excel-Macros$$ Require help on a condition

Thanks Sandeep, This is simplest way and yes the assumption is correct...the assumption sustains as it is assumed. Best Regards Pooja Sharma On Fri, Nov 20, 2009 at 8:13 PM, Sandeep Kumar Maurya sandymau...@gmail.com wrote: Hi, Find the attached sheet with formula. Regards Sandeep

$$Excel-Macros$$ Require help on a condition

Hi All, I've attached a file in which, a data is mentioned with the required solution. If any body can help me in this, it will be of great help. -- Best Regards Pooja Sharma -- -- Some important links for excel

Fwd: $$Excel-Macros$$ Re: Need a function or formula

Hi Kumar, Thanks for your kind help and support. But still when I'm trying this function in my database it is not showing the accurate way as it should be. I'm attaching the complete sheet where I've tried it with more data. Hope you will again resolve this. Best Regards Pooja Sharma On Wed

$$Excel-Macros$$ Re: Need a function or formula

:* $$Excel-Macros$$ Re: Need a function or formula Hi Pooja Pls find the attached sheet Hemant Hegde 2009/10/31 Pooja Sharma vatspoojav...@gmail.com Hi All, I need your help in extracting some words (having defined format) from one cell in another cell. Attached is a sheet where I

$$Excel-Macros$$ Need a function or formula

Hi All, I need your help in extracting some words (having defined format) from one cell in another cell. Attached is a sheet where I have mentioned the case and the solution I require. Hope you will help me. Best Regards Pooja Sharma

$$Excel-Macros$$ Need help regarding entering date

. If there is any other possibility then please guide me the way. -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video

$$Excel-Macros$$ Count of Colored Cells

to count the cells. -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http

$$Excel-Macros$$ Need Macros for Track Changes

to All as mentioned in Step 4 above. (I keep forgetting that) Hope this helps. -- Ashish Of what use is freedom if it does not include the freedom to make mistakes -- Mahatma Gandhi On 7/9/09, Pooja Sharma vatspoojav...@gmail.com wrote: Hi All, I want to know, if there is any other

$$Excel-Macros$$ Re: Need Macros for Track Changes

, Pooja Sharma vatspoojav...@gmail.com wrote: Hi All, I want to know, if there is any other option, i.e., other than Track Changes. I want to know in my excel sheet, if someone does any changes in any column/Row/Cell for e.g., Adding one row in between of existing rows, changing the values

$$Excel-Macros$$ Need Macros for Track Changes

, if someone has stop the Track Changes option, then it won't work. Therefore, I need to protect my data and find out if any invaluable changes are going on in a different workbook or in the different worksheet. -- Best Regards Pooja Sharma

$$Excel-Macros$$ Re: Counting duplicates once

counting one per name once (hope that makes sense). -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more

$$Excel-Macros$$ Re: How to filter , from data in cell.

) out from the data which is comma separated. Further I want to retain the . (dot) in data. The file is attached with this email. regards SACHIN -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http