Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel Functions = XL f(x)s XLfxs
  • Calculate hours between two cells ABS
  • Multiple-Validations (connected to each other) Data Validation
  • Blank (isempty) VS “” (null string) Excel User tips
  • Min Max vehicle Formulas - combined functions
  • Validation based on another Validation COUNTA
  • SimpleANBox Basic Math
  • Multiple Dual-Validations COUNTA

Category: VLOOKUP

Sorting with functions only

Posted on September 5, 2022 By ANmar
Sorting with functions only

This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.

Read More “Sorting with functions only” »

CHOOSE, Formulas - combined functions, LARGE, Lookup and References, MATCH, Math and Trig, ROW, SMALL, Standard functions, VLOOKUP

Searching table in 2 dimensions.

Posted on July 26, 2022 By ANmar
Searching table in 2 dimensions.

Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis.

This post has been sitting for a while in my archive, waiting for me to get some time to polish and post.

Read More “Searching table in 2 dimensions.” »

Formulas - combined functions, HLOOKUP, INDEX, Lookup and References, MATCH, Standard functions, VLOOKUP

Skills Grid

Posted on October 26, 2018 By ANmar
Skills Grid

A small Excel file to show how we can create a chart-like Excel sheet

Used in my Resume to show different skill sets and the level of expertise in each

Read More “Skills Grid” »

Conditional Formatting, Data Validation, Formulas - combined functions, IF, IFERROR, Logical, Lookup and References, Names, Non-functions, OFFSET, Standard functions, VLOOKUP, Worksheet

New function IFERROR, finally

Posted on December 24, 2017 By ANmar
New function IFERROR, finally

We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF

But, we do not need that anymore

We can use the new guy, IFERROR instead, which will show the result if it did not generate error, otherwise will show something else if it resulted an error.

Read More “New function IFERROR, finally” »

IFERROR, VLOOKUP

VLookup

Posted on September 26, 2016 By ANmar
VLookup

I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to post it here, but we need to fill requests from all types of visitors.

Vlookup is the most famous function in Excel, some people actually refer to Excel as VLookup.
Even though I do not like that fact, especially when we have other powerful functions like INDEX, OFFSET, INDIRECT and others.

So, what is VLOOKUP?

VLookup is going to search for an item in the left column of your table (or selection), as in the screenshot below, then bring me back the value in the same row where it find that item from another column.

 

Post1499

The Green box (Lookup_Value) is what the function will search for, and the vertical green box is where, this is because we selected the range (Table_Array) in Blue as the area of D:G, so VLookup will search in D, this is the V part in VLOOKUP, we should also expect to see HLookup.
Means if item is not found in column D, VLookup will return as #N/A error

Read More “VLookup” »

Lookup and References, Standard functions, VLOOKUP

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • 0% interest promotion Basic Math
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Progress bar in pure functions CHAR
  • Convert cell into textbox Excel User tips
  • Week number to Month number DATE
  • Formula Beautifier Excel User tips
  • Shades of gray Graphics
  • Hyperlink usage and HyperlinkOf UDF CELL

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme