Tom’s Tutorials For Excel: Looking Up the Address of an Item in a List
Here is a formula that returns the address of the cell in a list that contains a particular item. In the picture, cell D2 contains a Widget Stock Number, and cell E2 contains this array formula to return the item’s address:
Recall, an array formula is applied to a cell by simultaneously pressing the
Ctrl+Shift+Enter keys, not just
Enter. The curly braces are not typed in by you; Excel places them automatically when the array formula is properly applied.
If you are unfamiliar with array formulas, see my video and explanation of arrays here.