↓ Skip to Main Content
Tom Urtis
  • Home
  • About
    • Services
    • About Tom Urtis
    • Contact
  • Blog
    • Text Tutorials
    • VIdeo Tutorials
  • Store
  • XAT®
  • Links
  • Contact
Home › Excel › Lookup

Lookup

Posted on March 25, 2012 by Tom Urtis — No Comments ↓
Here are examples of VLOOKUP and various lookup alternatives:

Case sensitive lookup

Intersecting Lookup With Multiple Criteria

Handling multiple OR Lookup Criteria

Reverse intersecting lookup: return row and header labels

Lookup with multiple criteria

Lookup first and last values along row

Lookup and address of last instance

Reverse lookup

Lookup oldest and newest date

Lookup by MIN or MAX

Match from list

Lookup column header for first non-zero-containing cell along a row

HLOOKUP (introductory tutorial)


Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

*

*

CATEGORIES

  • ActiveX / Form Controls (10)
  • Array Formulas (27)
  • Cells Ranges Lists (122)
  • Charts and Chart Sheets (1)
  • Comments / Screen Tips (9)
  • Conditional Formatting (15)
  • Cut Copy Paste Clear Fill (16)
  • Data validation (12)
  • 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
  • Instagram
  • Linkedin
  • Youtube