arraysgoogle-sheetsgoogle-sheets-formulamatchvlookup
How to get criteria column dynamically using INDEX+VLOOKUP in Sheets?
One good soul has helped me get to this point, but I got one more contraint I'm trying to tackle:
How to populate Rep and Region based on the ID column, but this column may move, so getting this must be dynamic, just like getting Rep and Region columns is.
Here's the working formula, without the criteria:
=INDEX(VLOOKUP(ROW('From Sheet1'!A7:A); {ROW('From Sheet1'!A7:A)\ 'From Sheet1'!B7:C}; MATCH({"Rep"\ "Region"}; 'From Sheet1'!A7:C7; 0); 0))
Here's a sample data.
Appreciate your help, as usual!
Solution
try:
=INDEX(IFNA(VLOOKUP(A7:A,
{FILTER('From Sheet1'!A7:Z, 'From Sheet1'!7:7="ID"), 'From Sheet1'!B7:C},
MATCH({"Rep", "Region"}, 'From Sheet1'!A7:C7), 0)))
- Why is the spread operator needed for Math.max()?
- How to access multidimensional data from a json file?
- How to access multidimensional data with loops
- Difference between np.nan and np.NaN
- JS: Filter array of objects by max value per category
- Bash array with spaces in elements
- How to display a multidimensional array
- How to join / combine two arrays to concatenate into one array?
- How do I find a partial match from a data table to an individual cell?
- Parsing a string representation of nested arrays into an Array
- Pipe complete array-objects instead of array items one at a time?
- In Rust, is there any reason to use a `const` array vs array reference?
- How to set a Rust array length dynamically?
- Swift async Loop in Task
- How to print a bash array on the same line
- Looped process only shows the first result per iteration
- How to access a column value in a 2d array?
- Format 2d array data into a string of hyphenated consecutive day ranges based on a shared time range
- Create an array with same element repeated multiple times
- Difference between List and Array types in Kotlin
- Python list with NumPy arrays as elements
- SwiftUI Mapkit: How to reference values from an array for markers?
- How do I Merge two Arrays in VBA?
- Sum of corresponding values from different arrays of the same size with Python
- 2D array in YAML
- Dynamic multidimensional array in twig
- How to append something to an array?
- How does PHP determine the key to use if I declare array elements without offering explicit keys?
- searching an unordered integer array
- PHP JSON (decode)