If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup / Summary Table
I want Excel to lookup a value in a table and return each row it finds that
value in. As an example: Lookup Value: Ford Lookup Table: A1: Ford B1: Focus A2: Chevy B2: Malibu A3: Chevy B3: S10 A4: Ford B4: Ranger Results Table: A1: Ford B1: Focus A2: Ford B2: Ranger What I don’t want is: A1: Ford B1: Focus A2: B2: A3: B3: A4: Ford B4: Ranger In other words, I don’t want a bunch of blank rows in the new summary table. What function(s) can I use to create my summary table? |
Thread Tools | |
Display Modes | |
|
|