Looking for a solve returning list of values to cells A3:A?? that correspond to drop down list selection in cell A:1.
Drop down list references 2 column table in columns E & F. Values in column E correspond to validation list in A:1. Looking for formula to return corresponding values from column F.
<tbody>
</tbody>
Drop down list references 2 column table in columns E & F. Values in column E correspond to validation list in A:1. Looking for formula to return corresponding values from column F.
Toyota | Make | Model | |||
Ford | F150 | ||||
Prius | Ford | Taurus | |||
4Runner | Ford | Escort | |||
Land Cruiser | Honda | Civic | |||
Rav4 | Honda | Accord | |||
Toyota | Prius | ||||
Toyota | 4Runner | ||||
Toyota | Land Cruiser | ||||
Toyota | Rav4 | ||||
Chevy | Malibu | ||||
Chevy | Silverado |
<tbody>
</tbody>