100% Free & Secure

Multi-Criteria Lookup Tool

Match rows using two or more columns together and return the result from a matching record.

Primary File
The main dataset you want to enrich with new data.
Lookup File (Optional)
If you are matching within the same workbook, leave this empty.

Share this tool

Did this work well?

Why Use Multi-Criteria Lookup?

Simple, fast, and precise composite data matching

Composite Precision

Safely match rows that share multiple exact conditions, like First Name AND Last Name.

Lightning Fast

All processing happens locally in your browser with no upload delays.

100% Private

Your files never leave your device. Zero server uploads.

Online Multi-Criteria Lookup Tool - Free & Private

The Excel Multi-Criteria Lookup Tool lets you easily merge data by requiring multiple exact conditions to match simultaneously before returning a value.

What is this tool?

It is an online alternative to complex Excel array formulas like INDEX(..., MATCH(1, (A=...)*(B=...), 0)). It builds a structured composite key to find rows that satisfy every condition you map.

Understanding the Settings

Criteria Mapping

Each pair of columns you select acts as an AND condition. All pairs must match for a row to be considered found.

Return Column

The specific column that contains the data to pull in from the fully matched row.

First Full Match

If multiple rows in your lookup data satisfy all criteria, the tool will return the result from the first one it finds.

How Does It Work?

  1. Upload Files: Upload your primary file and an optional lookup file.
  2. Map Multiple Arrays: Select at least 2 column pairs that must match together (e.g., First Name and Last Name).
  3. Select Return: Choose the column you want to return from the matched record.
  4. Run Lookup: Process data instantly in your browser and download the result.

Why Use Our Multi-Criteria Lookup Tool?

  • Avoids writing complicated nested array functions in Excel
  • Extremely fast composite matching
  • Process huge files directly in your browser without slowing down your computer

Frequently Asked Questions

Common questions about multi-criteria matching

Does this use AND logic or OR logic?

This tool currently uses AND logic. A row must match every criteria pair you configure to be considered a successful match.

Our Free Excel & PDF Tools

Everything you need to manage, convert, and transform your spreadsheet files — all free, all private.

Excel File Merger

Merge multiple Excel files (XLS, XLSX, CSV) into one with smart column matching and conflict resolution.

Merge Files

PDF to Excel Converter

Extract tables and data from PDF documents into clean, editable Excel spreadsheets instantly.

Convert PDF

Excel Splitter

Split large Excel files into smaller pieces by rows, sheets, columns, formulas, and more.

Split Files

Excel to JSON Converter

Instantly convert Excel (XLS, XLSX) and CSV files to clean, formatted JSON. Features advanced options for nested structures, custom object arrays, and optimized output.

Convert to JSON

Mail Merge

Generate bulk personalized documents from Excel data using simple {{Tags}}. Download as a ZIP archive instantly.

Generate Documents

Image to Excel (OCR)

Extract text and tables from images using OCR technology. Convert photos and screenshots to Excel spreadsheets.

Convert Images →

JSON to Excel Converter

Convert JSON data into clean, structured Excel spreadsheets. Supports nested objects, arrays, and auto-type detection.

Convert JSON →

Compare Excel Files

Compare two Excel files side by side and instantly see cell-by-cell differences, added rows, and removed rows.

Compare Files

Excel to CSV Converter

Convert Excel files (XLS, XLSX) to CSV format instantly. 100% private client-side processing with no ad-heavy interruptions.

Convert to CSV

Remove Duplicates

Easily find and remove duplicate rows in your Excel files. Select specific columns to check and instantly download the cleaned file.

Remove Duplicates

Encrypt Excel File

Password-protect your sensitive Excel (XLSX) files. 100% private client-side encryption.

Encrypt File

Unlock Excel File

Remove password protection from encrypted Excel files instantly. 100% private local processing.

Unlock File

Compress Excel

Reduce the file size of large Excel workbooks (XLSX, XLS) without losing data or formatting.

Compress File

CSV to Excel Converter

Convert CSV, TSV, and delimited text files into formatted Excel spreadsheets with smart delimiter detection.

Convert CSV →