$$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: image.p

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, >> >&g

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

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

om. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful c

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

On Sun, Jul 8, 2012 at 2:25 PM, Pooja Sharma wrote: > Hi Priti and Ashish! > > Thanks a lot for your Help. > > > -- > *Best Regards > Pooja Sharma* > * > * > ** > *Smile is a beautiful curve, which sets everything straight. So keep > smiling... :) *

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 wrote: > *Please see the attached file* > > * * > > *Good info

$$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$$ Need a file on commonly used Formulas and Functions for MS Excel 2010

Hi All, Could anybody provide with a file of Formulas and Functions for MS Excel 2010. Regards Pooja Sharma Sent from BlackBerry® on Airtel -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

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

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 wrote: > Hi, > > Find the attached sheet with formula. > > Regards > Sandeep &g

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

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

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

:* Sunday, November 01, 2009 11:49 AM > > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Need a function or formula > > > > Hi Pooja > > > > Pls find the attached sheet > > > > > Hemant Hegde > > 2009/10/31 Pooja Sharma

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

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(Vide

$$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$$ Count of Colored Cells

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

the process mentioned in Steps 3-5 above > again. > > Important point is to make sure that you change the tab to "All" as > mentioned in Step 4 above. (I keep forgetting that) > > Hope this helps. > -- > > Ashish > > > "Of what use is freedom if i

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

> 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 wrote: >> >> Hi All, >> >> I want to know, if there is any ot

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

$$Excel-Macros$$ Help required on Condition or Formula.

Hi All, I need a help, with a condition in which I have to match a column with other two columns and if out of those two columns any of them match with the first column then the result will be "Match" otherwise "Mismatch" -- Best

$$Excel-Macros$$ Need help on the Vlookup formula

help me. -- 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 options, visit this group at

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

;s, > laptops's and CAD's are being used but only counting one per name once > (hope that makes sense)." > > > > -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macro

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

mma) 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 --~--~-~--~~~---~--~