Using Multiple Check Boxes to pull in Data from a table

Hi there,

I've been struggling all day with the proper formulas and functions to build a little excel app that can pull in data by clicking on two more more check boxes. Please see for what I've done so far:

Check Box Worksheet.xlsx

Table Check.gif

What I want to happen is the follow:

I click on a program check box and then the program name and impressions fill in the below cells according to what's checked. This is the formula I have currently in the "Program" cell:

Please Login or Register  to view this content.

This is what I have in the "Impression" cell:

Please Login or Register  to view this content.

Now I know this isn't the best way to do it since if you click on multiple programs in the list they just appear connected together in the "Program" cell. Please be aware it's really just a work in progress. What I would love to happen is each time you click on a program check box it just fills in the next available space in column B.

The data being pulled is coming from the below table. It's not all of the data as it's too long to attach.

Data Table.gif

Now secondly I need to have the "VPVH" and "Demo" cells fill in according to what's check under Demo Splits. For example, If you click on American Dad and then A18-49 I want the "Program" cell to read American Dad, the "Impressions" cell to read 508,409, the "VPVH" cell to read 0.93, and the "Demo" cell to be filled in as well. I'm using the IF function to pull in the data like so:

Please Login or Register  to view this content.

This works up until a point but I can't go farther than just the first check box.

Secondly, since i'm using the IF function combined with & signs the data just combines in the cell but I want it to appear in the cells under where American Dad would appear and so on and so forth if you click multiple. I'm having trouble finding out what functions to use but I'm getting there so any help would be appreciated. Let me know if you need more information.

Thanks!

Ryan

1. Please replace the picture with a workbook.
2. Please replace the [QUOTE] [/QUOTE] tags with [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing

I dont know what goes in the columns VPVH & Demo but here's a start: It uses the worksheet calculate event to update based on the program boxes checked.