Are you stuck on Excel or Google Sheets?

Check out our self-help content, created by our top Experts!

AND

  1. Excel AND function
  2. AND Function of Conditional Formatting

AVERAGE

  1. Average Growth Rate
  2. Moving Average
  3. Ignore Zeros
  4. How To
  5. Average top 3 scores
  6. Weighted average
  7. Average response time per month
  8. Average and ignore errors
  9. Average number
  10. Average last 5 values in columns

AVERAGEIF

  1. Google Sheets
  2. How to Use

CELL

  1. CELL

CELL REFERENCE

  1. Multiple Sheets

COLUMNS

  1. First column number in range

CONDITIONAL FORMATTING

  1. How to Use
  2. Row
  3. IF
  4. Greater Than
  5. Copy
  6. Color
  7. Apply Conditional Formatting to Blank Cells
  8. Based on
  9. Text
  10. Copy Text
  11. Formula
  12. How to Use
  13. SUMIFS in Google Sheets
  14. Remove file extension from filename
  15. Highlight top values
  16. Lookup entire row
  17. Highlight values between
  18. Highlight multiples of specific value
  19. Highlight dates in the next N days
  20. Highlight cells that equal
  21. Highlight 3 smallest values with criteria
  22. Highlight every other row
  23. Highlight dates that are weekends
  24. Highlight rows with blank cells
  25. Highlight row and column intersection exact match
  26. Highlight cells that begin with
  27. Highlight cells that end with
  28. Conditional formatting highlight target percentage
  29. Shade alternating groups of n rows
  30. DECIMAL
  31. Select all precedents
  32. Select all dependents
  33. Undo last action
  34. Conditional formatting dates overlap
  35. Highlight dates between
  36. Highlight duplicate values
  37. Highlight duplicate columns
  38. Find duplicate values in two columns
  39. Conditional formatting based on another cell
  40. Highlight approximate match lookup conditional formatting
  41. Most frequently occurring text
  42. Normalize text
  43. Excel SUMPRODUCT Function
  44. Conditional Formatting Dates in Excel
  45. Apply Conditional Formatting to an Entire Row
  46. Conditional Formatting Based on the Contents of a Cell
  47. Use Conditional Formatting to Highlight a Row or Column
  48. Conditional Data Validation
  49. Remove Conditional formatting
  50. Using Conditional Formatting Across Multiple Cells in Excel
  51. Use the OR Function of Conditional Formatting
  52. Conditional Formatting Times in Excel
  53. Conditional Formatting with 2 Conditions
  54. Conditional Formatting in Excel Based on Another Cell's Value

COUNT

  1. Function
  2. How to Count Non Blank or Non Empty Cells in Excel
  3. Blank/Empty
  4. Colored/Highlighted
  5. Google Sheets
  6. Duplicates
  7. Unique/Distinct Values
  8. count words in Excel
  9. Characters
  10. Text
  11. Summary count of non-blank categories
  12. Count cells that are blank
  13. Count cells not equal to a specified value
  14. Count cells that contain either a or b
  15. Count cells that contain specific text
  16. Count cells that do not contain
  17. Count cells that begin with
  18. Basic timesheet formula with breaks
  19. Count dates by day of week
  20. Count cells between dates
  21. Count cells greater than
  22. Count cells that are not blank
  23. Count cells that contain text
  24. Summary count with COUNTIF
  25. Count matches between two columns
  26. Count cells that contain errors
  27. Count cells not equal to many things
  28. Count sold and remaining
  29. Count cells over 100 characters
  30. Count cells that end with
  31. Count unique values in a range with COUNTIF
  32. Count rows that contain specific values
  33. Count items in list
  34. Count occurrences in entire workbook
  35. Count numbers by range with COUNTIFS
  36. Count cells between two numbers
  37. Count cells that contain odd numbers
  38. Count long numbers without COUNTIF
  39. Count cells that contain numbers
  40. Summary count with percentage breakdown
  41. Count if row meets multiple internal criteria
  42. Count cells that contain five characters
  43. Count visible rows only with criteria
  44. Count unique numeric values with criteria
  45. Count unique text values in a range
  46. Count cells that contain negative numbers
  47. Count cells that do not contain errors
  48. Running count of occurrence in list
  49. Two-way summary count with COUNTIFS
  50. Count cells equal to
  51. Count numbers third digit equals 3

COUNTA

  1. Not Blank
  2. Count vs Counta
  3. How to
  4. Google Sheets

COUNTIF

  1. Formula
  2. Between Two Values
  3. Multiple Criteria
  4. Non-Blank
  5. COUNTIF in Google Sheets
  6. Greater Than
  7. Countif Function / How to Use testing
  8. COUNTIF Function of Excel's Conditional Formatting

COUNTIFS

  1. How to Use COUNTIFS with Multiple Criteria and OR Logic

CUMIPMT

  1. Excel CUMIPMT Function

DATA ENTRY

  1. Multiple Sheets

DATA VALIDATION

  1. How to allow numbers only
  2. How to allow uppercase text only
  3. How to allow weekday dates only
  4. Check for specific text
  5. How to allow text only
  6. How to allow dates from a certain year only
  7. How to only allow dates in the next 30 days
  8. How to only allow values that don't exceed a set sum
  9. Data validation must begin with
  10. Data validation unique values only
  11. Data validation must contain specific text
  12. Data validation date in next 30 days
  13. Data validation date in specific year
  14. Data validation exists in list
  15. Data validation allow numbers only
  16. Data validation must not contain
  17. Data validation allow weekday only
  18. Data validation allow text only

DATABASE

  1. DCOUNT
  2. Excel DSTDEVP Function
  3. DVAR
  4. DGET
  5. DSUM
  6. DAVERAGE
  7. DCOUNTA
  8. DMIN
  9. DMAX
  10. DVARP

DATE

  1. Add Time in Excel
  2. Calculate Elapsed Time in Excel
  3. Determine Time Intervals in Excel
  4. Make a Time Difference Calculation in Excel  
  5. Highlight Rows with Dates Between in Excel
  6. Current Time in Excel
  7. Add Days in Excel
  8. Convert a Date to Unix Format in Excel
  9. Calculate Overtime in Excel

DATE AND TIME

  1. Get days between dates
  2. How to only allow values that don't exceed a set sum
  3. Dynamic date list
  4. Pad week numbers with zeros
  5. Sum race time splits
  6. DATE
  7. Next working day
  8. Next business day 6 months in future
  9. Get first Monday before any date
  10. Get first day of previous month
  11. Display the current date and time
  12. Year is a leap year
  13. Next anniversary date
  14. Next biweekly payday from date
  15. Convert date to text
  16. List holidays between two dates
  17. Working days left in month
  18. Get year from date
  19. Get workdays between dates
  20. If Monday, roll back to Friday
  21. Last updated date stamp
  22. Join date and text
  23. Get months between dates
  24. Get week number from date
  25. TIMEVALUE
  26. Get work hours between dates
  27. DAYS360
  28. Get month name from date
  29. Get same date next year
  30. Get same date next month
  31. Dynamic calendar grid
  32. Calculate expiration date
  33. Get first day of month
  34. Get days before a date
  35. Get days between dates ignoring years
  36. Get age from birthday
  37. Get nth day of week in month
  38. EDATE
  39. Get most recent day of week
  40. Display the current date
  41. Extract date from a date and time
  42. Sum time over 30 minutes
  43. Workdays per month
  44. DATEVALUE
  45. Add decimal hours to time
  46. Add days to date
  47. Get last day of month
  48. EOMONTH
  49. Get fiscal year from date
  50. Get days, months, and years between dates
  51. Count times in a specific range
  52. Convert Excel time to decimal minutes
  53. Convert Excel time to decimal hours
  54. Get day name from date
  55. MINUTE
  56. SECOND
  57. Get date from day number
  58. Extract time from a date and time
  59. Assign points based on late time
  60. Add workdays to date custom weekends
  61. NOW
  62. DATEDIF
  63. Convert text to date
  64. Get next day of week
  65. Add months to date
  66. Calculate number of hours between two times
  67. Get next day of week
  68. WORKDAY
  69. Get month from date
  70. Get day from date
  71. DAY
  72. Convert decimal seconds to Excel time
  73. Excel WEEKDAY Function
  74. TIME
  75. Custom weekday abbreviation
  76. YEAR
  77. Convert date to month and year
  78. Excel YEARFRAC Function
  79. Date is workday
  80. Basic overtime calculation formula
  81. Date is same month and year
  82. Days in month
  83. Create date range from two dates
  84. Count holidays between two dates
  85. Convert date to Julian format
  86. NETWORKDAYS.INTL
  87. Calculate years between dates
  88. Calculate days remaining
  89. Get last weekday in month
  90. Calculate date overlap in days
  91. Add workdays no weekends
  92. WEEKNUM
  93. How to calculate a retirement date
  94. Count day of week between dates
  95. Count dates in current month
  96. WORKDAY.INTL
  97. Get quarter from date
  98. Get percent of year complete
  99. Get project end date
  100. Get project midpoint
  101. Get project start date
  102. Date is same month

DATE SERIES

  1. Series of dates by workdays
  2. Series of dates by day
  3. Series of dates by year

ENGINEERING

  1. HEX2DEC
  2. DEC2HEX
  3. How to Use the Convert Function in Excel
  4. BIN2HEX
  5. BITOR
  6. BITAND function
  7. BITRSHIFT
  8. BIN2DEC

EXACT

  1. EXACT

FINANCIAL

  1. Calculate interest for given period
  2. Calculate simple interest
  3. PPMT
  4. Calculate payment for a loan
  5. Calculate interest rate for loan
  6. CUMPRINC
  7. Calculate original loan amount
  8. Financial
  9. Annual compound interest schedule
  10. Microsoft Excel IRR function
  11. FV
  12. Calculate cumulative loan interest
  13. Calculate principal for given period
  14. NPV
  15. PV
  16. XIRR
  17. Calculate cumulative loan principal payments
  18. NPER
  19. RATE

FIND

  1. How to
  2. Excel FIND Function

GENERAL

  1. Redo last action

GRID OPERATIONS

  1. Delete rows

GROUPING

  1. Map text to numbers
  2. Group times into 3 hour buckets
  3. Group arbitrary text values
  4. Group numbers at uneven intervals
  5. Group numbers with VLOOKUP

HEX2BIN

  1. HEX2BIN

IF

  1. write an IF statement
  2. IF AND
  3. Nested IF statements
  4. Blank / Not Blank
  5. IF OR
  6. IFERROR Function in Excel
  7. If this AND that OR that
  8. Tax rate calculation with fixed base
  9. Force negative numbers to zero
  10. If cell contains this or that
  11. Nested IF function example
  12. If else
  13. If this AND that OR that
  14. If cell is greater than
  15. If cell is x or y and z
  16. If cell is this OR that
  17. If this AND that
  18. If cell equals
  19. If a cell is not blank
  20. If cell contains

INDEX

  1. How to Use Excel INDEX function

INDEX MATCH

  1. Formula
  2. INDEX MATCH

INFORMATION

  1. ISTEXT
  2. TYPE
  3. N
  4. ISNUMBER
  5. ISFORMULA
  6. NA
  7. ISNONTEXT
  8. ERROR.TYPE
  9. ISBLANK
  10. SHEETS
  11. ISEVEN
  12. ISNA
  13. ISODD
  14. ISERROR
  15. INFO
  16. INFO

INTERNET

  1. Remove trailing slash from url
  2. Create email address from name
  3. Get top level domain (TLD)
  4. Strip protocol and trailing slash from URL
  5. Get page from URL
  6. Get domain name from URL

LEN

  1. Count total characters in a cell

LOG10

  1. LOG10

LOGICAL

  1. Excel TRUE function
  2. IFNA
  3. Extract data with helper column
  4. IFERROR
  5. IFS
  6. OR
  7. FALSE
  8. XOR
  9. Excel IF Function

LOOKUP

  1. How to Find the First Match in a Range with a Wildcard
  2. Lookup and retrieve an entire column
  3. Get location of value in 2D array
  4. Max if criteria match
  5. Partial match against numbers with wildcard
  6. Self-contained VLOOKUP
  7. VLOOKUP from another workbook
  8. Sum range with INDEX
  9. Exact match lookup with SUMPRODUCT
  10. Get first text value with HLOOKUP
  11. Get address of lookup result
  12. Two-Way Lookup with VLOOKUP
  13. VLOOKUP without #N/A error
  14. Calculate grades with VLOOKUP
  15. Position of first partial match
  16. Calculate grades with VLOOKUP
  17. Extract all partial matches
  18. Two-way lookup with INDEX and MATCH
  19. VLOOKUP with 2 lookup tables
  20. Lookup lowest value
  21. Basic INDEX MATCH Approximate
  22. Basic INDEX MATCH exact
  23. Match next highest value
  24. Find missing values
  25. Break ties with helper column and COUNTIF
  26. Next largest match with the MATCH function
  27. Match First Error
  28. Find the position of the max value in a list
  29. Join tables with INDEX and MATCH
  30. Lookup last file version
  31. Partial match with VLOOKUP
  32. Get information corresponding to max value
  33. Get nth match
  34. Basic Tax Rate calculation with VLOOKUP
  35. Count missing values
  36. Approximate match with multiple criteria
  37. Find longest string in column
  38. INDEX and MATCH with multiple criteria
  39. Extract Unique Items from a List
  40. Dynamic Lookup Table with INDIRECT Function
  41. Get the First Non-blank Value and Text Value in a List

Lookup and reference

  1. LOOKUP
  2. OFFSET
  3. INDIRECT
  4. ROW
  5. COLUMNS
  6. How to use the Excel CHOOSE function
  7. HLOOKUP
  8. INDEX
  9. TRANSPOSE
  10. MATCH
  11. ADDRESS
  12. COLUMN
  13. ROWS
  14. Excel HYPERLINK Function

MATCH

  1. one value exists
  2. List
  3. How to Use
  4. Last Row in Text Data

MATH

  1. SUM
  2. SUMPRODUCT
  3. TAN
  4. GCD
  5. ABS
  6. Excel LOG Function
  7. SUMIFS
  8. EVEN
  9. SIGN
  10. RAND
  11. Excel COS Function
  12. EXP
  13. SIN
  14. QUOTIENT
  15. LN
  16. SUMIF
  17. RANDBETWEEN
  18. ROMAN
  19. ROMAN
  20. ARABIC
  21. DECIMAL
  22. MOD
  23. POWER
  24. FLOOR
  25. MROUND
  26. ODD
  27. RADIANS
  28. SUBTOTAL

MIN

  1. MIN

MIN AND MAX

  1. Smaller of two values
  2. Large with criteria
  3. Larger of two values
  4. Maximum value
  5. nth smallest value with criteria
  6. Max value ignore all errors
  7. Minimum value if
  8. Minimum if multiple criteria
  9. Maximum if multiple criteria
  10. nth smallest value
  11. nth largest value with criteria
  12. Minimum value
  13. nth largest value
  14. nth largest value with duplicates

Miscellaneous

  1. Value is within tolerance
  2. Validate input with check mark
  3. Value is between two numbers
  4. Course completion summary with criteria
  5. Course completion status summary
  6. Transpose table without zeros
  7. Sum text values like numbers
  8. Copy value from every nth row
  9. Sum every 3 cells
  10. Square root of number
  11. Split payment across months
  12. Sort text and numbers with formula
  13. Sort numbers ascending or descending
  14. Pad a number with zeros
  15. nth root of number
  16. Convert column number to letter
  17. Reverse a list or range
  18. Random sort formula
  19. Sum/Return an Array with the Index Function
  20. Range Contains One of Many Substrings
  21. Range contains one of many values
  22. Basic text sort formula
  23. Student class enrollment with table
  24. Search entire worksheet for value
  25. Risk Matrix Example
  26. Range contains specific text
  27. Excel formula: One or the other not both
  28. How to Search Multiple Worksheets for Value
  29. Simple currency conversion
  30. Check register balance
  31. Build hyperlink with VLOOKUP
  32. Fixed value every N months
  33. Calculate a ratio from two numbers
  34. List most frequently occuring numbers
  35. Multiplication table formula
  36. Normalize size units to Gigabytes
  37. Abbreviate state names
  38. List Contains Duplicates
  39. Basic numeric sort formula
  40. Get value of last non-empty cell
  41. Hyperlink to first match
  42. Flip table rows to columns
  43. Conditional mode with criteria
  44. Get first entry by month and year
  45. Get pivot table subtotal grouped date
  46. Cube root of number
  47. Get Date Associated with Last Entry
  48. Get last entry by month and year
  49. Display sorted values with helper column
  50. Filter values in array formula
  51. Change Negative Numbers to Positive
  52. Create array of numbers
  53. Most frequently occurring number
  54. Flag first duplicate in a list
  55. Get last entry by month and year
  56. Issue response time calculation

MOD

  1. How to Use
  2. Get number at place value

N() FUNCTION

  1. Leave a comment in a formula

NAMES

  1. Join first and last name
  2. Get last name from name
  3. Get first name from name
  4. Put names into proper case
  5. Get first name from name with comma
  6. Get middle name from full name

OTHER

  1. GETPIVOTDATA

PERCENTAGE

  1. Project complete percentage
  2. Get original price from percentage discount
  3. Percent of goal in Excel
  4. Get profit margin percentage
  5. Percent sold
  6. Get total from percentage
  7. Decrease by percentage
  8. Get amount with percentage
  9. Calculate percent variance

PIVOT TABLE

  1. Calculated Fields
  2. Sort
  3. Transpose Data
  4. Conditional Formatting
  5. Percentage
  6. Distinct
  7. Google Sheets
  8. Refresh/Update
  9. How to Create/Make
  10. Calculated Field
  11. Source Reference not Valid Error in a Pivot Table
  12. Pivot Table Should Have a Dynamic Range
  13. Format the Values of Numbers in a Pivot Table
  14. Sort Data in a Pivot Table
  15. Use a Pivot Table to Find Unique Values in Excel
  16. Delete a Pivot Table
  17. Show Percentages in a Pivot Table
  18. Refresh a Pivot Table in Excel

QUARTILE

  1. QUARTILE

RANDOM

  1. Random times at specific intervals
  2. Random value from list or table
  3. Random number weighted probability
  4. Random text values
  5. Random number from fixed set of options
  6. Random number between two numbers
  7. Random date between two dates
  8. Randomly assign people to groups

RANGE

  1. All values in a range are at least
  2. All values in a range are at least
  3. Get relative column numbers in range
  4. Total cells in a range
  5. Range contains a value not in another range
  6. Last row in mixed data with blanks
  7. Range contains numbers
  8. First Match Between Two Ranges
  9. Last row in mixed data with no blanks
  10. Last row number in range

RANK

  1. How to use rank function
  2. How to RANK from lowest to highest
  3. How to RANK using COUNTIFS
  4. How to use RANK with suffix
  5. Rank with Criteria
  6. Rank function example
  7. Rank with Ordinal Suffix

ROUND

  1. Round to nearest 1000
  2. Round a number up
  3. Excel ROUNDUP function
  4. Round a number
  5. Round a Number Down To Nearest Multiple
  6. Round a price to end in .99
  7. Round a Number to Nearest Multiple
  8. Get integer part of a number
  9. ROUND
  10. Round a number down
  11. Get Excel to Stop Rounding Your Numbers
  12. Round Decimal Values in Excel
  13. Round Multiple Cells at Once in Excel

ROW

SELECT SPECIAL

  1. Display 'Go To' dialog box

SQRT FUNCTION

  1. SQRT

STATISTICAL

  1. QUARTILE.EXC
  2. QUARTILE.INC
  3. VARPA
  4. VARA
  5. VARP
  6. VAR.S
  7. VAR.P
  8. VAR
  9. TRIMMEAN
  10. STDEVPA
  11. STDEVP
  12. STDEVA
  13. STDEV.S
  14. STDEV
  15. STDEV.P
  16. AVERAGE
  17. LARGE
  18. PERCENTILE.EXC
  19. PERCENTRANK
  20. COUNTBLANK
  21. AVEDEV
  22. COUNTIF
  23. COUNTA
  24. COUNT
  25. DEVSQ
  26. MINA
  27. AVERAGEIF
  28. FREQUENCY
  29. AVERAGEIFS
  30. MODE.MULT
  31. MEDIAN
  32. GEOMEAN
  33. PERCENTILE
  34. Excel MODE Function
  35. PERMUT
  36. PERCENTILE.INC
  37. MAX
  38. PERCENTRANK.EXC

SUM

  1. How to
  2. Autosum in Excel
  3. 3D Sum Multiple Worksheets
  4. Sum last n columns
  5. Sum if multiple criteria
  6. Sum sales in last 30 days by ID
  7. Sum by Week Number
  8. Sum if equal to one of many things
  9. Sum Bottom N Values with Criteria
  10. Sum if cells contain specific text
  11. Sum if cell contains text in another cell
  12. Sum if cells are equal to
  13. Sum entire column
  14. Sum if by year
  15. Sum if not blank
  16. Sum if greater than
  17. Subtotal by color
  18. Sum every nth column
  19. Sum by group
  20. Sum If Ends With
  21. Sum columns based on adjacent criteria
  22. Sum if begins with
  23. Sum if cells contain both x and y
  24. Sum if one criteria multiple columns
  25. Sum visible rows in a filtered list
  26. Sum if equal to either x or y
  27. Sum by weekday
  28. Sum by week
  29. Sum Top n Values with Criteria
  30. Sum if cells contain an asterisk
  31. Subtotal invoices by age
  32. Sum every n rows

SUMIF

  1. Google Sheets
  2. Multiple Criteria
  3. Blank / Not Blank
  4. How to Use SUMIF to Sum Values Between Two Dates
  5. Sum if between
  6. Use SUMIF Combined with Multiple Criteria
  7. Combine SUMIF with GREATER THAN and LESS THAN Functions
  8. Using SUMIF with the Time Format
  9. Add Values within a Date Range using SUMIFS
  10. Using the SUMIF Function for Adding Between Two Values
  11. Comparing SUMIF vs COUNTIF vs AVERAGEIFS to Deal with Multiple Criteria
  12. Use the SUMIF and OR Functions Together
  13. Use the SUMIF Function Across Multiple Sheets
  14. Apply the SUMIF Function to Negative Criteria
  15. Sum Time in Excel
  16. Use SUMIF to Sum Cells Based on Background Color
  17. Using SUMIF to Add Cells If They Contain Certain Text

SUMPRODUCT

  1. All cells in range are blank

SWITCH

  1. SWITCH

TABLES

  1. Count table columns
  2. Basic inventory formula example
  3. Dynamic Reference of Table name
  4. Two-way lookup VLOOKUP in a Table
  5. Get column index in Excel Table

TEXT

  1. Join text together
  2. TEXTJOIN
  3. UPPER
  4. VALUE
  5. Replace one character with another
  6. CHAR
  7. Remove unwanted characters
  8. Remove characters from right
  9. Remove text by variable position
  10. Remove leading and trailing spaces from text
  11. Remove text by position
  12. Remove text by matching
  13. Remove line breaks
  14. Remove file extension from filename
  15. Split text string at specific character
  16. Split text and numbers in Excel
  17. Cell equals one of many things
  18. REPLACE
  19. LEFT
  20. Strip non-numeric characters
  21. Split dimensions into two parts
  22. Count keywords cell contains
  23. RIGHT
  24. CODE
  25. Count total words in a cell
  26. Cell contains number
  27. MID
  28. TRIM
  29. Add a line break with a formula
  30. Cell Contains All of Many Things
  31. Clean and reformat telephone numbers
  32. Excel PROPER Function
  33. Double quotes inside a formula
  34. Excel REPT Function
  35. Count specific words in a range
  36. Count specific words in a cell
  37. Remove characters from left side of a cell
  38. LOWER
  39. Count specific characters in a range
  40. Count total characters in a range
  41. Cell contains some words but not others
  42. DOLLAR
  43. Count line breaks in cell
  44. Count total words in a range

VLOOKUP

  1. Calculation
  2. Formula
  3. Compare
  4. Conditional Formatting
  5. Error
  6. Multiple Columns
  7. Multiple Sheets
  8. Check if one column value exists
  9. How to
  10. Google Sheets VLOOKUP function
  11. Not Working
  12. INDEX MATCH versus VLOOKUP
  13. IF
  14. Multiple Workbooks
  15. Fuzzy Lookup
  16. VLOOKUP with two client rates
  17. Lookup value between two numbers
  18. Get nth match with VLOOKUP
  19. VLOOKUP from another sheet
  20. VLOOKUP by date
  21. Calculate shipping cost with VLOOKUP
  22. Lookup up cost for product or service
  23. VLOOKUP with numbers and text
  24. Apply a VLOOKUP Between Worksheets
  25. VLOOKUP with Multiple Workbooks
  26. VLOOKUP with Multiple Criteria
  27. Lookup with Variable Sheet Name
  28. Pull Values from Another Worksheet in Excel
  29. Using VLOOKUP with Multiple Lookup Tables: Best Practices
  30. The Essential VLOOKUP Troubleshooting Guide
  31. Nested VLOOKUP Formula Examples
  32. Make VLOOKUP Reference Left Column in Excel
  33. Copy a VLOOKUP Formula Down a Column
  34. #REF Error with VLOOKUP
  35. VLOOKUP vs. HLOOKUP
  36. VLOOKUP with Two Criteria
  37. Get a Date to Automatically Update
  38. Lock a VLOOKUP from a Table Array
  39. #N/A Error with VLOOKUP
  40. VLOOKUP vs. Index Match
  41. VLOOKUP with the IF Condition
  42. Backwards VLOOKUP
  43. VLOOKUP vs. LOOKUP
  44. Combine the SUMIF and VLOOKUP Functions in Excel
  45. Pull Data from Another Sheet in Google Sheets
  46. VLOOKUP from Another Sheet: Formula Examples
  47. Use VLOOKUP with Multiple Criteria

WORKBOOK

  1. List sheet index numbers
  2. Get sheet name only
  3. Dynamic workbook reference
  4. Worksheet name exists
  5. Dynamic worksheet reference
  6. Get workbook name only
  7. Get workbook name and path without sheet
  8. Indirect named range different sheet