google sheets vlookup multiple criteria

reddit.com › r/googlesheets › vlookup with two match criteria

r/googlesheets on Reddit: Vlookup with two match criteria

July 7, 2023 -

Hi! I’m trying to do a vlookup with two match criteria, I’ve tried doing so with an IF formula but it keeps telling me I have two many arguments.

Basically I’m trying to find impressions based on a project name, but the second criteria is it’s broken out by day and has to match the day. Anyone have tips on what the correct formula for this is?

Here is the link to the sheet and what I'm trying to populate is highlighted in yellow. https://docs.google.com/spreadsheets/d/1nkHlUr9QxSlWHKZ8M-gYn0zJOOmdMGY-Ktc4n1gONh0/edit?usp=sharing

Top answer

1 of 5

You have two options really. Create a helper column which concatenates your two criteria columns into a "key" column which you then use with a normal VLOOKUP. E.g. in your helper column cell (say, C2) you'd have =A2&B2 Assuming your two criteria lookup columns are A and B, helper column is C, and results (what you want to bring back) is in D, in your VLOOKUP you do the same thing. =VLOOKUP(A2&B2,C:D,2,FALSE) Or Use INDEX and MATCH, and lookup 1 in a boolean array matching both criteria columns. E.g. =INDEX(result_column, MATCH(1,((criteria_col_one=criteria1)*(criteria_col_two=criteria2)),0),1) VLOOKUP won't accept two criteria, so these are the most straightforward ways I use to achieve a similar thing.

2 of 5

I like to use Sheets' query function. =QUERY([Range being Searched], "select A,B,C where A='"&[Cell Reference 1]&"' and B='"[Cell Reference 2]&"' ")

Xlookup (or vlookup) with multiple columns for lookup and result range possible? Oct 5, 2023

r/googlesheets

2y ago

Vlookup IF equation - Need to reference different columns based on criteria? Jun 7, 2023

r/googlesheets

3y ago

Google Sheet VLOOKUP Array with multiple conditions Nov 24, 2021

r/googlesheets

4y ago

How to lookup a Value based on two Criteria? Jun 15, 2021

r/googlesheets

5y ago

How to run an XLOOKUP with multiple criteria? Nov 26, 2024

r/googlesheets

last yr.

More results from reddit.com

Ben Collins

benlcollins.com › home › vlookup multiple criteria in google sheets

How to Vlookup Multiple Criteria and Columns in Google Sheets

June 20, 2024 - Learn how to use Vlookup with multiple criteria, by combining input criteria, creating helper columns or searching with dynamic arrays.

Discussions

Vlookup with multiple criteria - Google Docs Editors Community

Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com

support.google.com

August 1, 2022

VLOOKUP with multiple criteria?

Hello there, I would use a filter if I were you, here is the formula: =IFNA( FILTER($C$3:$C$7,$B$3:$B$7=$F4,$D$3:$D$7=G$3)) paste the formula above in F4 and drag down and right to fill in the rest. More on reddit.com

r/googlesheets

April 17, 2023

Google Sheet Vlookup Multiple Criteria - Stack Overflow

I have a Database sheet with a list of products and each product's details including but not limited to the product size, cost, department and more. On a separate sheet named PriceTiers, I have a l... More on stackoverflow.com

stackoverflow.com

VLookup Multiple Criteria Google Sheets - Stack Overflow

0 Google sheets filter multiple columns using OR but returns AND result More on stackoverflow.com

stackoverflow.com

Videos

youtube.com

4 Easy Tricks to VLOOKUP with Multiple Criteria (Google Sheets) ...

May 22, 2025

youtube.com

How to use VLOOKUP with multiple conditions in Google Sheets - YouTube

October 26, 2024

03:43

YouTube

How to use VLOOKUP with multiple criteria in Google Sheets ...

July 17, 2023

19:04

YouTube

How to do a VLOOKUP with multiple conditions or criteria (3 methods) ...

Vlookup With Multiple Criteria in Google Sheets - YouTube

February 17, 2021

12:35

YouTube

VLOOKUP from Multiple Worksheets (Tabs, Sheets) or ...

October 27, 2020

View all

Vlookup

vlookup.com › google-sheets › vlookup-multiple-criteria

VLOOKUP with multiple criteria in Google Sheets

In Google Sheets, VLOOKUP cannot natively search with multiple criteria. Use VLOOKUP with a helper column to join multiple criteria together.In this example, we'll find someone's email address based on their first and last name:

Google Support

support.google.com › docs › thread › 173386451 › vlookup-with-multiple-criteria

Vlookup with multiple criteria - Google Docs Editors Community

August 1, 2022 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on

Owox

owox.com › blog › articles › google sheets tips › vlookup with multiple criteria in google sheets made easy

VLOOKUP with Multiple Criteria in Google Sheets in 2025

May 25, 2026 - Learn how to use VLOOKUP with multiple criteria in Google Sheets. A step-by-step guide with examples to simplify your lookups without helper columns

Coupler.io Blog

blog.coupler.io › home › vlookup google sheets explained: how to search data vertically in spreadsheets

VLOOKUP Google Sheets Explained | Coupler.io Blog

August 5, 2025 - For this, you can merge cells using the ampersand (&) as follows: A1&" "&B1. ... Note: Read more about Merging Cells in Google Sheets. If you want to vlookup multiple values, you need to use two or more formulas wrapped in curly brackets.

Vlookup

vlookup.com › google-sheets › vlookup-multiple-matches

VLOOKUP with multiple match results in Google Sheets

In Google Sheets, VLOOKUP cannot natively return multiple values from multiple matches. Use FILTER to look up all the matches and return the corresponding values.

Find elsewhere

Google Bing Mojeek

Google Support

support.google.com › docs › answer › 3093318

VLOOKUP - Google Docs Editors Help

VLOOKUP can’t be directly applied on multiple criteria.

Ablebits

ablebits.com › ablebits blog › google sheets tips › google sheets functions › index match in google sheets – another way for vertical lookup

INDEX MATCH in Google Sheets – another way for vertical lookup

April 24, 2020 - You can try incorporating wildcard characters or try Multiple VLOOKUP Matches and see how it handles partial matches. ... Sheet 1 = google form responses with email address and scores Sheet 2 = Column A = full name and column B = their email address Sheet 3 = Column A = full name and column B = scores

reddit.com › r/googlesheets › vlookup with multiple criteria?

r/googlesheets on Reddit: VLOOKUP with multiple criteria?

April 17, 2023 -

https://imgur.com/a/nkoxcQt

I am creating a budget overview document consisting of multiple projects and a timeline in months. The structure is that project managers fill in the budget in a list of projects wich they update with new preojects as they come in, and then the overview presents that budget. I have created a mockup of the problem.

The issue I'm having is that I wanted to use VLOOKUP to match the budget with the project, but I also need to fill the criteria that the month matches. I have tried FILTER function and IF (specifically IF(D3:D=G1,VLOOKUP(F4,B3:C7,2),0)) but nothing has worked. I feel like there should ba an easy solution to this but I am drawing blank. Any help is very appriciated!

Top answer

1 of 5

Hello there, I would use a filter if I were you, here is the formula: =IFNA( FILTER($C$3:$C$7,$B$3:$B$7=$F4,$D$3:$D$7=G$3)) paste the formula above in F4 and drag down and right to fill in the rest.

2 of 5

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: Fewer Letters | More Letters | Last usage | Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions | Last usage | Evaluates a value. If the value is an #N/A error, returns the specified value. | Learn more | Last usage | Returns the content of a cell, specified by row and column offset | Last usage | Returns the relative position of an item in a range that matches a specified value | N | Returns the argument provided as a number | Last usage | Runs a Google Visualization API Query Language query across data | VLOOKUP | Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found [Thread #5644 for this sub, first seen 17th Apr 2023, 08:03] [FAQ] [Full list] ^[Contact] [Source code]

Stack Overflow

stackoverflow.com › questions › 79009465 › google-sheet-vlookup-multiple-criteria

Google Sheet Vlookup Multiple Criteria - Stack Overflow

Top answer

1 of 1

Converting the drag-down formula to array-style:

=map(A:A,H:H,I:I,W:W,X:X,AT:AT,lambda(a,h,i,w,x,at,
 IF(ROW(a)=1,"Price Line Lookup",IFERROR(IF(a="",,
IF(i>50,
DGET(PriceTiers!A:AC,"Price Line Code",{"Subcategory Code",                      "SU-Min","SU-Max","Cost_Min","Cost_Max";h,                "<="&x,">="&x,"<="&at,">="&at}),
DGET(PriceTiers!A:AC,"Price Line Code",{"Subcategory Code","Size_Min","Size_Max","SU-Min","SU-Max","Cost_Min","Cost_Max";h,"<="&w,">="&w,"<="&x,">="&x,"<="&at,">="&at})))))))

linkedin.com › pulse › episode-105-how-do-vlookup-multiple-conditions-criteria-al-chen

Episode #105: How to do a VLOOKUP with multiple conditions or criteria (3 methods)

September 26, 2022 - The reason you need to wrap this in an ARRAYFORMULA is because you are telling Google Sheets to look at all cells in a column (an array) instead of one cell at a time. The "result" of the ARRAYFORMULA is a list of 0s and 1s where the 1s represent rows that meet all the conditions: So we have a list of 0s and 1s, now we need to join it with the actual list of values we want to return from our VLOOKUP function (the Fuel_Type column).

Stack Overflow

stackoverflow.com › questions › 74097338 › vlookup-multiple-criteria-google-sheets

VLookup Multiple Criteria Google Sheets - Stack Overflow

Top answer

1 of 1

instead of

A:A&B:B; C:C

use

A:A&B:B\ C:C

for more info see: locale differences in google sheets (documentation missing pages)

Google Sheets

sheetsformarketers.com › home › blog › how to vlookup multiple criteria in google sheets

How to VLOOKUP Multiple Criteria in Google Sheets - Sheets for Marketers

October 31, 2023 - In this guide, we will show you how to use the VLOOKUP function to search for multiple criteria in Google Sheets.

Coursera

coursera.org › coursera articles › data › data analytics › how to use vlookup in google sheets

How to Use VLOOKUP in Google Sheets | Coursera

August 8, 2026 - Here are some more ways you can ... keys. The most common way to approach a VLOOKUP with multiple criteria is to create a “helper column.”...

Statology

statology.org › home › google sheets: use vlookup with multiple criteria

Google Sheets: Use VLOOKUP with Multiple Criteria

July 29, 2022 - This tutorial explains how to use VLOOKUP with multiple criteria in Google Sheets, including an example.

Spreadsheet Point

spreadsheetpoint.com › home › formula posts › how to use vlookup with multiple criteria

How to Use VLOOKUP with Multiple Criteria

June 3, 2024 - By concatenating the criteria into a single string, VLOOKUP can effectively search for values based on multiple conditions. The helper column method involves adding an extra column to the dataset, while the ARRAYFORMULA method constructs a dynamic ...

Stack Overflow

stackoverflow.com › questions › 79152830 › vlookup-function-for-criteria-contained-in-a-multiple-selection-drop-down-list

google sheets - Vlookup function for criteria contained in a multiple selection drop down list - Stack Overflow

Top answer

1 of 1

You could directly use the split data in VLOOKUP, search argument, if it's inside a ARRAYFORMULA:

=ARRAYFORMULA(VLOOKUP(SPLIT(B2,", ",FALSE),B$19:C$30,2,0))

To sum within array context, use SUMPRODUCT:

=SUMPRODUCT(VLOOKUP(SPLIT(B2,", ",FALSE),B$19:C$30,2,0))

Zapier

zapier.com › productivity › app tips

How to use VLOOKUP in Google Sheets: A complete guide

March 19, 2026 - This error can occur if you use VLOOKUP in Google Sheets to look up a value for which no exact match exists in your first column. Let's say you want to see how many products a customer purchased, but you have multiple customers with the same name (looking at you, Tim Johnson). Normally, the VLOOKUP function is limited to one search value, but you can scan for multiple criteria ...

InfoInspired

infoinspired.com › home › google docs › spreadsheet › vlookup with multiple criteria in google sheets: the proper way

VLOOKUP with Multiple Criteria in Google Sheets: The Proper Way

July 4, 2024 - HomeGoogle DocsSpreadsheetVLOOKUP with Multiple Criteria in Google Sheets: The Proper Way ... VLOOKUP with multiple criteria involves using two or more lookup values, each located in different columns in Google Sheets.