Use VLOOKUP and INDIRECT Functions Together in Excel
You can use the VLOOKUP and INDIRECT functions together in Excel to look up a value in a table in a different worksheet…
Tag: file
Highlight Rows Based on Drop Down List in Excel
As we work with Excel, we may want to highlight rows in a dataset based on the selection on a drop-down list in…
Excel VLOOKUP With Multiple Results
Although VLOOKUP is a very useful formula and can help us get the results we want with success and easier, certain shortcomings are…
Return Blank Cell Instead of Zero in Excel Formulas
As we work with Excel, we may want to return blank cells instead of zeroes in formulas. For example, we could return blank…
Use Excel Formulas in Word Documents
Excel formulas can enhance the functionality and capabilities of Word documents. For example, because of Word’s limited mathematical capabilities, if we need to…
VLOOKUP by Column Name in Excel
Most of the things that people use in Excel can be combined to achieve proper and adequate results. Using the VLOOKUP function is…
Sorting Order in the VLOOKUP function in Excel
VLOOKUP function is certainly one of the most widely used functions in Excel. Once we extract the data that we want from our…
Use VLOOKUP if Cell Contains Word within Text in Excel
VLOOKUP formula in Excel can be used in combination with a lot of different formulas and text options to help us with extracting…
Calculate the Mode in a Pivot Table in Excel
As we work with Excel, we may want to calculate the mode (most frequently occurring value) in a Pivot Table. This tutorial shows…
VLOOKUP with CONCATENATE in Excel
One of the most useful functions in Excel is VLOOKUP. It can be combined with different functions as well. In the example below,…
