Index/ Match/ Lookup questions

**[email protected]** · 10-04-2012, 01:57 PM

Hi there. I have question related to the spreadsheet I uploaded.
Basically, on tab 1 I have a drop down menu that lists 3-4 contractor names.
I want to populate the table on sheet 1 with the corresponding values on sheet 2 based on the drop down value.
I've attached the spreadhsheet for clarification. I am not sure if this is possible.

Thanks

**Pepe Le Mokko** · 10-04-2012, 02:49 PM

There's only one name in your dropdown. Also first get rid of merged cells, they are nothing but trouble

**[email protected]** · 10-04-2012, 07:14 PM

I've modified the cells to remove the merging. I also added the other items to the
drop down menu. I've tinkered with some index/match but no luck so far

**[email protected]** · 10-05-2012, 09:33 PM

Any takers?

**FDibbins** · 10-05-2012, 09:57 PM

not sure where your drop-down comes into play, but use this in D19, copied down and across
=INDEX($G$2:$K$9,MATCH($B19,$H$2:$H$9,0),MATCH(D$18,$G$1:$K$1,0))

Also note that the headings in both tables MUST be identical, or you will get an error msg