arraysgoogle-sheetsgoogle-sheets-formulavlookupindex-match
match a range on query function in google sheets
I am trying to create an arrayformula that matches the column from a certain sheet to the current sheet. I have a list of names (Column B) in sheet1 with its value (Column C), and in sheet2 i have all the names in a different order, and i want to bring their respective values to the current sheet, i have tried the following formula but it only matches the first value which is A2 and not the rest to the A14
=ARRAYFORMULA({"Match";IF(ISBLANK(A2:A14),"",IFERROR(QUERY(Sheet1!$B$2:$C$14, "select C where B matches '"&A2:A&"' "),0))})
Any help will be very much appreciated.
Solution
use:
=INDEX(IFNA(VLOOKUP(A2:A, Sheet1!B:C, 2, )))
- PHP: How to remove specific element from an array?
- Array-size macro that rejects pointers
- c++: storing some structured data containing diffrent datatypes in a single entity
- Copy one 2D array to another 2D array
- Using 2 input coordinates of the chess board, identify whether or not they crossed each other's path (using queen moves of the chess game)
- How do I know an array contains all zero(0) in Javascript
- How to extract N elements every M elements from an array?
- Extract values from arrays in
- Accessing comptime array in runtime with for loop
- Generate read-address and write address for zig-zag scan of NxN matrix
- sorting in mongodb aggregation according to timestamp
- C# best way to convert object to string array
- Python Iterating over Numpy Tile and for-loops
- Leetcode 643. Maximum Average Subarray I
- Javascript twoSum algorithm: Given an array of integers, return indices of the two numbers such that they add up to a specific target
- Create the xAxys with a array of strings instead of an array of integers - Highcharts
- Appropriate applications for the as_strided function
- Can somebody give a snippet of "append if not exists" method in swift array?
- How to find the sum of an array of numbers
- How to quickly find the minimum element to the right for every element of a Numpy array?
- Convert complex NumPy array into (n, 2)-array of real and imaginary parts
- Transform a multidimensional array from PDO to two simple arrays for a chart
- Create json-encoded array from a PDO query result column
- C2664 cannot convert argument from 'initializer list'
- Shortening list of numbers with hyphens between consecutive numbers
- Explanation of Python numpy array operations timing behavior
- Jmeter: unable to extract value from nested array
- Efficient way of re-numbering elements in an array
- How to get First 10 Values of array with PHP
- Remove duplicate values from JS array