HomeExcel GuideLookup & Reference Functions

Lookup & Reference Functions

FILTER Function in Excel: Ultimate Guide

Inar Learn -
FILTER Function in Excel: Ultimate Guide { "@context":"https://schema.org","@type":"Article", "headline":"FILTER Function in Excel: Ultimate Guide", "description":"Master the Excel FILTER function with syntax, dynamic...
Read more

INDEX Function in Excel: Ultimate Guide

Inar Learn -
If VLOOKUP is the workhorse of Excel, INDEX is the sports car. It is faster, more flexible, and forms the backbone of the most...
Read more

MATCH Function in Excel: Ultimate Guide

Inar Learn -
The MATCH function is one of Excel’s most powerful, yet frequently misunderstood, tools. While functions like VLOOKUP return the actual data found in a...
Read more
spot_img
Lookup & Reference Functions

FILTER Function in Excel: Ultimate Guide

FILTER Function in Excel: Ultimate Guide { "@context":"https://schema.org","@type":"Article", "headline":"FILTER Function in Excel: Ultimate Guide", "description":"Master the Excel FILTER function with syntax, dynamic...
Inar Learn -
Lookup & Reference Functions

INDEX Function in Excel: Ultimate Guide

If VLOOKUP is the workhorse of Excel, INDEX is the sports car. It is faster, more flexible, and forms the backbone of the most...
Inar Learn -
Lookup & Reference Functions

MATCH Function in Excel: Ultimate Guide

The MATCH function is one of Excel’s most powerful, yet frequently misunderstood, tools. While functions like VLOOKUP return the actual data found in a...
Inar Learn -
Lookup & Reference Functions

XLOOKUP Function in Excel: Ultimate Guide

XLOOKUP is Excel’s modern, flexible lookup function. It replaces many common uses of VLOOKUP, HLOOKUP, and INDEX/MATCH. XLOOKUP is available in Microsoft 365, Excel...
Inar Learn -
Lookup & Reference Functions

HLOOKUP Function in Excel: Ultimate Guide

HLOOKUP stands for Horizontal Lookup. It searches for a value in the top row of a table and returns a value from the same...
Inar Learn -
Lookup & Reference Functions

VLOOKUP Function in Excel: Ultimate Guide

VLOOKUP is one of Excel’s most useful lookup functions. It searches for a value in the first column of a table and returns a...
Inar Learn -

Popular Articles

How JavaScript Works: A Beginner’s Guide

Inar Learn - 0
Learn how JavaScript works, from how browsers execute code to the JavaScript engine, runtime, call stack, event loop, and how JavaScript interacts with web pages.

How JavaScript Runs in a Web Browser

Inar Learn - 0
Learn how JavaScript runs in a web browser, including script loading, JavaScript engines, execution, the call stack, event loop, and interaction with the DOM.

CSS Rules: Selectors, Properties and Values Explained

Inar Learn - 0
Learn how CSS rules work, including selectors, properties, and values, with practical examples for writing clear and effective CSS styles for webpages.

CSS Comments: How to Add Comments in CSS

Inar Learn - 0
Learn how to add CSS comments, including CSS comment syntax, single-line and multi-line comments, best practices, and practical examples for clean, maintainable code.

CSS Case Sensitivity: What You Need to Know

Inar Learn - 0
Learn how CSS case sensitivity works, including selectors, property names, values, class and ID names, with practical examples and best practices for writing reliable CSS.