Forum Discussion
How to identify cell values based on 2 colums? Excel
I have a list of customer names in one column. names will be repeated. If I enter a specific name, all the cells corresponding to that name should be listed in another column. Left part is questi...
=IFERROR(INDEX($A$2:$A$24,SMALL(IF($B$2:$B$24=D$1,ROW($B$2:$B$24)-1),ROW($A1))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021. The formula is in cell D2 and copied across range D2:E10.
An alternative could be the FILTER function if it's available in your version of Excel.