attached is the sheet i am trying to make function...
this sheet, the yellow bar is a dropdown of the the names of the 5 bars to the left, i want the white boxes under it to return the values of the information UNDER the bars on the left. for example, if A is selected, all the white boxes would fill with 1, if B is selected, it would return all 2's since that is whats to the left.

i believe index match is the best way to do this, unless i am mistaken for a better way to search a grid? thanks all.

demo.xlsx