Techniquices

From  How to vlookup and return multiple values vertically in Excel? (extendoffice.com)   How to vlookup and return multiple values (vertically) in Excel? Normally, you can use the Vlookup function to get the first corresponding value, but, sometimes, you want to return all matching records based on a specific criterion. This article, I will talk about how to vlookup and return all matching values vertically, horizontally or into one single cell. Vlookup and return all corresponding values vertically Vlookup and return all corresponding values horizontally Vlookup and return all corresponding values into one cell Vlookup and return all corresponding values vertically To return all matching values vertically based on a specific criterion, please apply the following array formula: 1 . Enter or copy this formula into a blank cell where you want to output the result: =IFERROR(INDEX($B$2:$B$15, SMALL(IF($D$2=$A$2:$A$15, ROW($A$2:$A$15)-ROW($A$2)+1), ROW(1:1))),"" ) Note : In the a