WAY TO GET INFORMATION

Suppose you have a report where users should only be able to enter particular values in a cell. You can create a dropdown menu to limit what they’re able to choose from. Using the example from this VLOOKUP , if you want to look up an employee’s salary, you should only be able to use correct names of employees and weed out types. (Note: In the current post, the VLOOKUP for finding the employee’s salary has been updated to search based on the employee’s name instead of employee ID. The table array is now B1:C11 and the column index number is 2.)  Select the cell where you want the list. In this example, we’ll use H1, where we’ll select the employee’s name. In the ribbon, select go to the Data Tab and select Data – Data Validation. Under Settings, in the Allow menu, select List.    Click your cursor into the Source field and highlight the cells with the values you want to choose from in the dropdown menu.   Click OK at the bottom of the popup windo...

How to do a vlookup between two spreadsheets If you know the name of a product, for instance, and you want to quickly determine its price, you can simply enter the product name into Excel and VLOOKUP will find the price for you. To the novice Excel user, however, setting up VLOOKUP can look like an intimidating process -- but it needn't be. Just follow our step-by-step tutorial to start using VLOOKUP today.  1. Click "Lookup & Reference"  on the Ribbon.   . 2. Click "VLOOKUP"  at the bottom of the drop-down menu.   3. Specify the cell  in which you will enter the value whose data you're looking for. In this case, our lookup value is H2, since this is where we will input the name of a tournament such as "PGA Championship," so we input "H2" in the lookup_value box of the popup window. Once we've set up VLOOKUP properly, Excel will return the tournament's Total Rating Value in cell H3 when we type the tournament ...