Excelhub.org vlookup and more
How to use Vlookup wildcard search in excel
In excel formulas; we can use the wildcard for partial matches to get the results. This can be used many functions where we do matching to get the results. Similarly, we can use the wildcard in vlookup formula. In this post I will explain you how to use vlookup wildcard in excel formula. You can also download the sample excelREAD MORE
Excel VBA to Display search result in listbox
In case if you have a large list of employee data in a sheet and you want to select one employee details in main sheet based on the employee number. You can put a vlookup table and the details can be retrieved based on id in that table as below. But in case if you cant remember all employee id’s,READ MORE
Vlookup multiple sheets with same formula with Vlookup with Indirect
With the combination of Vlookup and Indirect functions, you can dynamically change the sheet name in the formula to Vlookup multiple sheets with same formula. How to use Vlookup multiple sheets with Indirect In VLOOKUP Function you can search the given value from a table and give the output for matching value. In case if you have data table inREAD MORE
Excel autocorrect feature and tricks to save time
While typing in excel, you might have seen that excel will do many auto correct functions. We can customize the autocorrect features in excel as per our requirement. To go to excel autocorrect options, follow the below steps: Click on Office buttonClick on Excel options and thenClick on Proofing Click on AutoCorrect options. It gives various options and you can customiseREAD MORE
How to insert drop down list in excel
In various web pages and software you might have seen drop down list.This drop down list allows us to select the input without any error. Now let’s see advantages of drop down list and how to insert drop down list in Excel : it will give options to the user to select the input easily and quickly the input given byREAD MORE
How to add the developer tab to the ribbon
In case you want to learn macros, vba programming and want to become advanced user of excel, you will have to add the developer tab to the ribbon. By default in excel this will not be added in the ribbon. How to add the developer tab to the ribbon in excel 2007 ? Click on excel Office Button Click onREAD MORE
How to find duplicates in excel- 3 ways to check for duplicates
As a part of data analysis , in excel we can find and remove duplicate values. there are different ways to remove duplicates in excel. In this article let us understand how to find duplicates in excel. 3 Different ways to check duplicates: There are three different ways to find duplicates in excel. Conditional formating to find duplicates Using RemoveREAD MORE
How to lock cell and protect sheet in excel
Excel provides the facility to protect sheet from updating from users. We can define the cells to be protected and cells to be allowed to be used in the sheet in a same sheet. The cells not protected will be allowed for user for updating the data and the protected cell can’t be altered by the users. The protection canREAD MORE
Free Software ITR 1 Sahaj income tax return for AY 2018-19
What is ITR 1 and who can file this. ITR 1 Sahaj form can be filed by individuals with the income up to Rs. 50 Lakhs and with the following income. Salary or Pension Income Income from one house property ( excluding loss brought from previous year) Income from other sources (excluding winning from Lottery and Income from Race Horses)READ MORE
Hide formulas in excel and protect worksheet from update
The Formula bar shows the formula entered in a cell when the cell is selected. In case if you have entered some complicated formula which you don’t want to show to the user, you can hide formulas in excel sheet without hiding the results of the formula. By doing this the results will appear without any impact. To hide formulasREAD MORE
Comments
Post a Comment