Lookup Value From an Array and place values in boxes next to it?

**soundengineer** · 03-01-2009, 10:02 PM

I have an array with a bunch of Transmission types and respective gear ratios
I have a dropdown menu with the Transmission types in it..
when I select a transmission I want a few cells to be automatically filled in with the correct gears
Meaning I pick T56 and in the 6 cells next to it they get filled with the appropriate 6 gears

**Steve R** · 03-02-2009, 02:47 AM

Can you post a sample workbook?

**soundengineer** · 03-02-2009, 03:08 AM

Originally Posted by Steve R

Can you post a sample workbook?

here ya go...
Drop down box and 6 cells next to it
select the Transmission in the Dropdown box and I want to fill in the cells with the respective gear values

**DonkeyOte** · 03-02-2009, 03:14 AM

Based on your file:

B16: =INDEX(B$2:B$12,MATCH($A$16,$A$2:$A$12,0))
copy across as required.

Note: it would make sense to store the result of the MATCH in one cell (say H16) and reference that in each formula B16:G16 rather than computing the same calc over and over in each column (ie row to return is constant for all columns)