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...
As the other responder mentioned, if able to use FILTER this would be considerably more dynamic, especially if using table referencing. To make your data a table, you can use the shortcut Ctrl+T. An example to accomplish the filtering with a table would be:
=FILTER(PartNums[PN],PartNums[Manufacturer]=E$1,"")
I named the table PartNums for ease of use, but make that whatever you'd like, and make your criteria of E$1, F$1, G$1, etc. the cells where you are inputting your manufacturers' names.