Dropdown List and Auto Populate

nzrocketman

New Member
Joined
Mar 15, 2014
Messages
11
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
 

Attachments

  • Photo 2.jpg
    Photo 2.jpg
    228.3 KB · Views: 9
  • Photo 1.jpg
    Photo 1.jpg
    166.5 KB · Views: 9

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,127,802
Messages
5,626,984
Members
416,213
Latest member
neflerine

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top