arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
If blank return 0 else run vlookup
I would like to use the vlookup function to match two criteria values firstly based on the value selected in a dropdown menu (country) and the value in A2(name). If the value in A2 Sheet matches the one of the values in the A column in Sheet2 and the value of the dropdown menu in Sheet1 matches one of the values in Sheet2 Column D (Which is a concatenation of the name and country) I would like to return the corresponding value in Sheet2 ColumnC.
If the value is 0 or blank I would like to return 0.
This is what I have tried
=ARRAYFORMULA(
IF(
ISBLANK(
IFERROR(VLOOKUP(A2&C2,Sheet2!$A$2:$E$61,3,1),"0"))))
Not sure what I might be doing wrong
Here is a sample of my data
Sheet 1:
A B C
name1 (vlookup) [dropdownmenu]
and Sheet 2
A B C
name1 val concatenationofA&B
Here is a test sheet as requested:
https://docs.google.com/spreadsheets/d/1jsFnaGY7N9nXyPs5vR32jG5G838w1SgB2XIad7bEFXg/edit?usp=sharing
Solution
try:
=ARRAYFORMULA(IFNA(VLOOKUP(A2:A&C2:C, {Sheet2!A2:A&Sheet2!B2:B, Sheet2!C2:C}, 2, 0), 0))
- LENGTH of ARRAY [42883]: ERROR: function array_length(text[]) does not exist
- Lodash _.hasIntersection?
- Converting to char*** from char* [2][2]
- TypeScript how to sort an array into an array
- C# Parsing JSON array of objects
- Passing an array to numpy.dot() in Python implementation of Perceptron Learning Model
- How to show String of array text in curve shape in SwiftUI?
- How do I check if variable is an array?
- Split a delimited string and create single-element associative rows from the values with a static key
- Traverse over tree type structured data uing JavaScript
- Determine the size of an InputStream
- Merge associative row data from a 2d array to another 2d array on shared id column values
- Can not create Function array in Java 8
- How do I compare two UTF-8 strings ignoring case in Zig language?
- Populate a flat array of values from a column within a column of a 4-level array
- How to convert character array (char[]) to String array (String[]) without looping through char array and by using predefined methods in java?
- PowerShell doesn't return an empty array as an array
- Converting 2D array to 1D Array without using ArrayList
- How can I, having two arrays, remove elements of the second array to the first array - PostgreSQL?
- What am I doing wrong in this question- Search in Rotated Sorted Array...?
- Convert csv file data to json
- Convert a 2D array into a 1D array
- How to sort an array in Bash
- Convert text with two delimiters into a 2d array
- Convert two dimensional array to one dimensional array in Java
- Twig - How to randomise items in the array and loop them?
- Explode semicolon delimited string and iterate every two values
- In MongoDB : Slice array of objects from slicing index array and push in array through aggregation
- PHP: extract data from XML string and add to array
- Split the delimited values in a flat array and populate arrays with column values