Vlookup and drop down

[johnny4strings]

Hello everyone-

I'm going crazy here trying to do something relatively simple. I am just trying to run a vlookup or a match/index to find values when I use a drop down menu. I consistently either get n/a or Ref errors. I am jut attempting to get values from the data table (on the left) to populate on the right when the pertinent selections is made from the dropdown.

I am basically trying to sort/list wiring amounts completed by supervisor name. This table will be extended downward to reflect the 100 types of wire we have. I will have dynamic charting that changes depending on the selection.

Thanks everyone for taking the time to help me!!!!!!!!!!
J