Google Sheets vlookup based on multiple criteria with wildcards
I'm trying to extend a gs vlookup formula with a 2nd criteria.
This formula works fine with 1 criteria in column A. =ArrayFormula(IFNA(VLOOKUP(""&A2:A&"",sheet2!C:D,2,FALSE), ""))
But I would like to extend the formula with a 2nd (OR) criteria . That sould somehow look like this: =ArrayFormula(IFNA(VLOOKUP(""&A2:A&"" OR ""&B2:B&"",sheet2!C:D,2,FALSE), "")) (The fomula shoud check if one of the 2 criterias (in column A or B) matches with column C on sheet2 and return the value from D on sheet2)
Is this even possible with a fomula?
This formula seems to do what you're looking for, placed in C2:
=ArrayFormula(
IFNA( VLOOKUP(A2:A,Sheet2!C:D,2,0),
IFNA(VLOOKUP(B2:B,Sheet2!C:D,2,0),"no match")))
I think there are several other ways of doing this, but I went with what you'd started with.
I haven't added error checking yet, for blank rows, etc., to keep it straightforward.
- Using FILTER with multiple conditions on Google Sheet
- How to union ranges in google spreadsheets
- Formula for filtering list based off of key with multiple criteria in Google Sheets
- Conditional Dropdowns in Google Sheets Based on Multiple Criteria
- Arrayformula Serial Number by Groups
- List rows in array when the cell contain number in the string
- ImportXML XPath issue using Google Sheets on a simple web scraping query
- How to find the Second Space from the right in Google Sheets?
- Find if cell contents exist in array
- OR function not working with arrayformula in Google Sheets
- Is there a way to COUNTIF the number of partial name matches (REGEXMATCH) within a column of cells?
- Using IMPORTXML on Google Sheets to extract image URLs
- How can I make this formula more dynamic by including another criteria (cell F11) in the query?
- Using a reference cell as part of a column in a google sheets query
- Can a formula return corresponding values from one column into another, removing blanks and separating them with commas?
- Using Named Functions with New Google Tables
- Google sheets query not returning words with special characters
- Trying to figure out why my GoogleSheets Date formula is not working
- Why is this conditional formatting rule not working in Google Sheets?
- Google Sheets ARRAYFORMULA with Partial Match and Multiple Criteria Not Returning Expected Results
- Why does my Google Sheets query simplificaiton result in an error?
- How do I set up a formula that matches columns between two sheets, while returning blank values for the first two rows regardless of values
- I do not understand the error message displayed when I try to use QUERY() function in Google Sheets
- In Google Sheets, how do I keep a cell blank based on two other cells' contents?
- Removing protection from a range of cells before automatically deleting with a google script based on date
- How to insert yesterday's date in googlesheet
- How use loop variable in column or row number?
- Google sheets - find the cell containing specific text
- Google sheets formula for showing remaining time per month for descending list of weeks
- Use Lambda to stack multiple query array