Dropdown List and Auto Populate

[nzrocketman]

Hi,

Having trouble with 2 areas.

Issue 1 - Dropdown List

I am trying to Create a dropdown list at "Sheet1" D1 from the data shown in photo 1 Sheet "Calculations" Cells B1:XY1 and only have it show the one that have an 1 underneath in B2:XY2

Issue 2 - Auto Populate

So then i am trying to make a Cell, = the data in the Calculation sheet based upon the Select column in the dropdown list.

So if you are compare the 2 photos

for example, Cell M13 wants to look up the number in Column C (0210) and grab the data from the correct VO column in the calculation sheet and match the Column C Number with the list in the A Column and insert the value into the M13

Hope this makes sense

Cheers

Brendon

 

[nzrocketman]

File can be found here

VO-Workbook.xlsm

1drv.ms