arraysexcelexcel-formulavlookupmultiple-records
How can I return multiple employee training record from a huge dataset. Currently I'm only getting one return value using a VLOOKUP
I'm looking to search a user ID and have the return show all training that is in the current dataset..I have included a small snap shot to show what I mean.
I've used a VLOOKUP but it's only returning the one value.
I'm thinking an INDEX MATCH but I'm unsure if it will work. Someone suggested an IFERROR instead?
Solution
It is an array formula, so confirming the formula with Ctrl+Shift+Enter.
Please try.
=IFERROR(INDEX($E$2:$E$6, SMALL(IF($A$2:$A$6=I$1, ROW($A$2:$A$6)-1,""), ROW(1:99)), 1), "")
Microsoft reference document:
- Explode string only once on first occurring newline character
- How to make all array keys the same as their respective value?
- what is the wrong with this javascript function?
- Batch matrix multiplication in numpy
- How to reindex an array after extracted from a larger array?
- How to patch form array in typed angular reactive forms
- Isolate a column of values from an array of objects
- Use an array of words to match and an array of replacements to perform replacements on a string
- Calculate a new column and remove other columns within nested objects of a multidimensional object
- Parse an array of delimited values into a flat, associative array
- Parse a text file into an array of associative arrays by splitting on semicolons then by equals signs
- How to access a deeply nested value in a multidimensional array?
- Loop only retains last item iterated
- How to access the second level values of a 2d array?
- How to use ref mut for an array?
- Why do PHP array examples leave a trailing comma?
- Split each value of a flat array at delimiter and create separate arrays from each half
- Iterate over integer in javascript where each value equals a single digit
- How to see if an object is an array without using reflection?
- How to fill in missing months in an array using javascript
- Group array values by prefix
- Split qualifying colon-space separated strings in an array to form a new associative array
- Isolate a single column of values from an array of objects
- Transpose the data from multiple flat arrays to create an indexed array with associative rows
- Group rows of a 2d array by the year and month values from a year-month column to create subarrays in each group
- Simplify API response payload to a 2d array with standardized second level keys
- How to declare an associative array?
- Group multidimensional data by one column and create subarrays in each group
- How to get unique values from an array of objects in a Map?
- How to access data in an array of objects containing arrays of objects?