hi, There are two lookups. vLookup and hLookup. it is to find the particular value with a reference of an item in two tables. vLookup for vertical searching and hLookup for horizontal search. Take an example: you have an excel table sheet one with country name in column a and the capital in column b. Assume that this table contains all countries of the world. and has a data from a1 to b200
Now in sheet number 2, if you just type the name of a country in column say c1; and if you desire let excel automatically write the capital of that country in cell d1 In this case, you can use vLookup command. in sheet2, cell d1; you have to write the formula: =vlookup(c1, sheet1!a1:b200,2) now if you change the name of the country in cell c1 of sheet 2, the corresponding name of the capital will be written in cell d1 of sheet2. No change The value of d1 is looked insheet 1 and written at the cell containing the lookup formula. Enjoy. For further more, read help. On 7/11/14, Selva Kumar <selvak...@gmail.com> wrote: > Hai dear Mailing list members > > I have doubt in excel > What is V lookup?,what is the use of it?, and Can we creat chart in > excel what is the use of it? > Can anyone clear my doubt > > Thanks > Regards Selvakumar > > > > > > > > > On 7/9/14, Mahesh Narasimhan <maheshde...@gmail.com> wrote: >> Hi Kavita and all the list members, >> >> I just tried the Filter and you try the following. You might like it. >> >> Step 1: Make a table. >> Step 2: Sort it by selecting the table. >> Step 3: Go to the column head which you want to filter. >> Step 4: Press Alt+A to go to the "Data Menu", then press down arrow to >> activate it. >> Step 5: Press Tab till you reach Filter Submenu; here you press right >> arrow ones and then press Tab till you reach custom filter. Here >> please press the Enter key. Then type the value that you want and >> press Tab till Ok and press Enter on Ok. >> >> Hope this works. >> >> Cheers! >> >> -- >> Good friendship is like the relationship between eye & hand! If the >> hand is hurt, the eye will cry! & when the eye cries, the hand will >> wipe the tears!!! >> With best regards, >> Mahesh Narasimhan >> M: +91(0)9899353960 >> E: maheshde...@gmail.com >> >> >> >> On 7/9/14, Neha Agarwal <tweety....@gmail.com> wrote: >>> Hello >>> No worries, its an individual choice. >>> Long method was shared as requested step by step guidance >>> Cheers >>> Neha >>> >>> Sent from my iPhone >>> >>>> On 07-Jul-2014, at 15:57, echo glad <gladecho...@gmail.com> wrote: >>>> >>>> thankyou so very much... got to learn a new thing in the simplest way >>>> instructed by Zoher Kheriwala... sorry didn't try the other methods by >>>> neha and arvind... the very first proved so much short cut... (as i >>>> like short cuts while working in the shortest time periods/durations) >>>> >>>>> On 7/6/14, Aravind R <aravind.andhrab...@gmail.com> wrote: >>>>> shortest step is going to the header of the column and pressing >>>>> ctrl+shift+l then pressing alt+down arrow. >>>>> >>>>>> On 7/5/14, Neha Agarwal <tweety....@gmail.com> wrote: >>>>>> Hi Kavitha, >>>>>> >>>>>> Find the steps below. >>>>>> 1. Focus on the header row and press alt key to open the menus. >>>>>> 2. Press right arrow key till you reach data menu/tab. >>>>>> 3. press down arrow key to open the data menu/tab. >>>>>> 4. In the sort and filter sub menue you will find the option of >>>>>> filters, hit enter on it. >>>>>> 5. Now you are in your work area of the sheet. Go to the contacts >>>>>> column. You will find a dropdown menu, press alt+down arrow key to >>>>>> open the dropdown menue. >>>>>> 6. Press down arrow key till you reach the check boxes anouncing your >>>>>> yes/no/reject/blanks. >>>>>> 7. you have 2 ways to get the data here. >>>>>> 1st, there will be the check box called 'all' by hitting space bar on >>>>>> it uncheck that and press down arrow key till you hear 'yes >>>>>> unchecked' >>>>>> hit space bar on it then press tab and hit enter on the ok button. >>>>>> You >>>>>> are done with the filtered data as desired. >>>>>> 2nd, Keep 'all' option checked and press down arrow key and uncheck >>>>>> the 'no'/ 'reject' / 'blank'by hitting space bar on it then tab hit >>>>>> enter on ok button. You are done . >>>>>> 8. Press down arrow key and see the results as desired. >>>>>> Hope this helps. >>>>>> >>>>>> Cheers >>>>>> Neha >>>>>> >>>>>>> On 7/5/14, Kavitha Desai desai <kavitha.desa...@gmail.com> wrote: >>>>>>> Hello friends, >>>>>>> >>>>>>> Can any of the list members help me regarding filtering data in >>>>>>> particular column. >>>>>>> >>>>>>> There is a huge data in Excel sheet 2007. >>>>>>> >>>>>>> One column contains heading as contacts. >>>>>>> >>>>>>> This column cells has data as yes, no, reject & blankscells. >>>>>>> >>>>>>> I want to only filter the cells which contains yes. >>>>>>> >>>>>>> So how can i filter this data on Excel 2007,. >>>>>>> >>>>>>> Please guide me step by step as I am using Windows XP as well as >>>>>>> Windows 7 Ultimate. >>>>>>> >>>>>>> Regards, >>>>>>> >>>>>>> Kavitha >>>>>>> >>>>>>> >>>>>>> >>>>>>> Register at the dedicated AccessIndia list for discussing >>>>>>> accessibility >>>>>>> of >>>>>>> mobile phones / Tabs on: >>>>>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>>>>>> >>>>>>> >>>>>>> Search for old postings at: >>>>>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>>>>>> >>>>>>> To unsubscribe send a message to >>>>>>> accessindia-requ...@accessindia.org.in >>>>>>> with the subject unsubscribe. >>>>>>> >>>>>>> To change your subscription to digest mode or make any other >>>>>>> changes, >>>>>>> please >>>>>>> visit the list home page at >>>>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>>>> >>>>>>> >>>>>>> Disclaimer: >>>>>>> 1. Contents of the mails, factual, or otherwise, reflect the >>>>>>> thinking >>>>>>> of >>>>>>> the >>>>>>> person sending the mail and AI in no way relates itself to its >>>>>>> veracity; >>>>>>> >>>>>>> 2. AI cannot be held liable for any commission/omission based on the >>>>>>> mails >>>>>>> sent through this mailing list.. >>>>>> >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> Neha Agarwal, >>>>>> PC/PMA-Project services, >>>>>> IBM India, Hyderabad , AP. >>>>>> >>>>>> >>>>>> >>>>>> Register at the dedicated AccessIndia list for discussing >>>>>> accessibility >>>>>> of >>>>>> mobile phones / Tabs on: >>>>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>>>>> >>>>>> >>>>>> Search for old postings at: >>>>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>>>>> >>>>>> To unsubscribe send a message to >>>>>> accessindia-requ...@accessindia.org.in >>>>>> with the subject unsubscribe. >>>>>> >>>>>> To change your subscription to digest mode or make any other changes, >>>>>> please >>>>>> visit the list home page at >>>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>>> >>>>>> >>>>>> Disclaimer: >>>>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking >>>>>> of >>>>>> the >>>>>> person sending the mail and AI in no way relates itself to its >>>>>> veracity; >>>>>> >>>>>> 2. AI cannot be held liable for any commission/omission based on the >>>>>> mails >>>>>> sent through this mailing list.. >>>>> >>>>> >>>>> -- >>>>> nothing is difficult unless you make it appear so. >>>>> >>>>> r. aravind, >>>>> >>>>> D R O in bank of baroda, >>>>> >>>>> mobile no: +91 9940369593, >>>>> email id : aravind_...@yahoo.com, aravind.andhrab...@gmail.com. >>>>> >>>>> >>>>> >>>>> Register at the dedicated AccessIndia list for discussing >>>>> accessibility >>>>> of >>>>> mobile phones / Tabs on: >>>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>>>> >>>>> >>>>> Search for old postings at: >>>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>>>> >>>>> To unsubscribe send a message to >>>>> accessindia-requ...@accessindia.org.in >>>>> with the subject unsubscribe. >>>>> >>>>> To change your subscription to digest mode or make any other changes, >>>>> please >>>>> visit the list home page at >>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>> >>>>> >>>>> Disclaimer: >>>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking >>>>> of >>>>> the >>>>> person sending the mail and AI in no way relates itself to its >>>>> veracity; >>>>> >>>>> 2. AI cannot be held liable for any commission/omission based on the >>>>> mails >>>>> sent through this mailing list.. >>>> >>>> >>>> >>>> Register at the dedicated AccessIndia list for discussing accessibility >>>> of >>>> mobile phones / Tabs on: >>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>>> >>>> >>>> Search for old postings at: >>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>>> >>>> To unsubscribe send a message to >>>> accessindia-requ...@accessindia.org.in >>>> with the subject unsubscribe. >>>> >>>> To change your subscription to digest mode or make any other changes, >>>> please visit the list home page at >>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>> >>>> >>>> Disclaimer: >>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking >>>> of >>>> the person sending the mail and AI in no way relates itself to its >>>> veracity; >>>> >>>> 2. AI cannot be held liable for any commission/omission based on the >>>> mails >>>> sent through this mailing list.. >>> >>> >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>> >>> To unsubscribe send a message to >>> accessindia-requ...@accessindia.org.in >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >>> Disclaimer: >>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >>> the >>> person sending the mail and AI in no way relates itself to its veracity; >>> >>> 2. AI cannot be held liable for any commission/omission based on the >>> mails >>> sent through this mailing list.. >>> >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the >> mails >> sent through this mailing list.. >> > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > > To unsubscribe send a message to > accessindia-requ...@accessindia.org.in > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- Him Prasad Gautam Kathmandu, Nepal Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
