↓ Skip to Main Content
Tom Urtis
  • Home
  • About
    • Services
    • About Tom Urtis
    • Contact
  • Blog
    • Text Tutorials
    • VIdeo Tutorials
  • Store
  • XAT®
  • Links
  • Contact
Home › Posts tagged math
Blog Archives

Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula.

by Tom Urtis No Comments ↓

Keywords: Excel 365; Excel 365; XLOOKUP; match_mode; math

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: Excel 365, match_mode, math, XLOOKUP

CATEGORIES

  • ActiveX / Form Controls (10)
  • Array Formulas (27)
  • Cells Ranges Lists (122)
  • Charts and Chart Sheets (1)
  • Comments / Screen Tips (9)
  • Conditional Formatting (20)
  • Cut Copy Paste Clear Fill (16)
  • Data validation (16)
  • Date Time (53)
  • Duplicates Uniques (13)
  • Filter Subtotal Group (9)
  • Find Replace Substitute (18)
  • Formats Fonts Styles Colors (49)
  • Formulas Functions (152)
  • Keyboard Mouse (35)
  • Links Hyperlinks Web Email (12)
  • Macros Events Classes API (110)
  • Numbers and Decimals (49)
  • Pictures Shapes Graphics (4)
  • Pivot Tables / Pivot Charts (10)
  • Printing Page Setup (7)
  • Sort (7)
  • Text and Constants (19)
  • Tips and Tricks (55)
  • User-Defined Functions (6)
  • UserForms (10)
  • Word Outlook Access PPT (8)
  • Worksheets Workbooks (60)
Tweets by @TomUrtis
  • Postal addressSan Francisco, California
  • Phone Number1-925-310-4170
  • Emailtom@atlaspm.com
  • Facebook
  • Twitter
  • Linkedin
  • Youtube