We even have guides on how to use conditional formatting in Excel to color-code specific cells and how to add comments to your formulas in Microsoft Excel. For example, when you protect a sheet or workbook, all of the cells will be locked, but you can also lock cells individually by right-clicking and selecting 'Format Cells.' And if you need to, you can also freeze rows and columns by selecting 'Freeze Panes' in the View tab.īut not everyone is a fan of Excel, so if you need to convert Excel spreadsheets to Google Sheets, we have a guide for that, as well as a guide on how to open Google Sheets in Excel.įor business users, we also have 10 Excel business tips that can help you keep your job, including guides on how to remove duplicate data, recover lost Excel files, use pivot tables to summarize data, and more. There are a number of neat tips that'll help you out when you're managing your Excel spreadsheets.

For example, if you have one worksheet with names and phone numbers and another sheet with names and email addresses, you can put the email addresses next to the names and phone numbers by using VLOOKUP. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. Using VLOOKUP, you can not only search for individual values, but also combine two worksheets into one. Formulas are the key to getting things done in Excel. We can use a table or single column to lookup the value.

In simple terms, the VLOOKUP function says the following to Excel: Look for this piece of information (e.g., bananas), in this data set (a table), and tell me some corresponding information about it (e.g., the price of bananas). Enter the value whose data you're searching for. Vlookup function is used to lookup the value with a reference cell and fetch the value from the selected lookup table array and is quite useful and one of the most widely used excel functions. The VLOOKUP function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/information.

Do vlookup in excel