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. Click the Formulas tab at the top of the window. We use a mixture of absolute and relative. above), or wrap them inside the CONCATENATE function.
Again, you can use the simple version of the cell references (as in 2. Next, enter the VLOOKUP with CONCATENATE formula into the first cell under the ‘High’ column header. There are a number of neat tips that'll help you out when you're managing your Excel spreadsheets. Click the cell where you want the VLOOKUP formula to be calculated and appear. Double-click the right-hand corner of the cell to fill down the column. 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 the Multi-condition Lookup dialog box, please do the following operations: (1.) In the Lookup Values section, specify the lookup value range or select the lookup value column one by one by holding the Ctrl key that you want to vlookup values based on (2. Excel 2016 for Office 365 subscribers on Windows and Mac now supports a new XLOOKUP function, touted as a considerably simpler and more versatile replacement for the very popular (yet oft maligned) vertical lookup function, VLOOKUP (don’t know what the X in XLOOKUP stands for eXtensive, perhaps). Using VLOOKUP, you can not only search for individual values, but also combine two worksheets into one.
Enter the value whose data you're searching for.