Associate a column data to another column data from a worksheet to another

**matamorevictor** · 10-15-2012, 03:01 PM

Hi!

I've been trying to find a function to have an association made from a worksheet to the other. To help you all understand the situation, I've attached an image below.

Here is what I would like to do:

- In the "Shots" Worksheet, in Column C, I have a dropdown list created from the "Artists" Worksheet. I want to pick an artist name from that dropdown list.
- Then, when the option is selected from that dropdown list, in "Shots" Worksheet, Column I ("Cost"), I would like to display a multiplication of:

Time Total (Shots Worksheet, Column H) x (Cost (Shots Worksheet, Column I) x Selected Artist Hourly Rate (Artists Worksheet, Column C)

That way, when the artist is chosen and that the required amount of time is entered, I automatically get the cost value based on the hourly rate of that artist.

Anyone knows how to do this? I'm stuck...

Thanks!

EXCEL_Screenshot.jpg

**FDibbins** · 10-15-2012, 03:18 PM

upload the sample file, not a picture

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**matamorevictor** · 10-15-2012, 04:17 PM

Sorry about this. First timer here!

Here is the file.

**FDibbins** · 10-15-2012, 08:54 PM

you had no drop-down or data validation for the artist.

also, i think you made a type in your requirement

- Then, when the option is selected from that dropdown list, in "Shots" Worksheet, Column I ("Cost"), I would like to display a multiplication of: 
Time Total (Shots Worksheet, Column H) x (Cost (Shots Worksheet, Column I) x Selected Artist Hourly Rate (Artists Worksheet, Column C)

you are trying to run a calc in column I, based on a value in column I. that is a monor concern, im sure you can correct that yourself

for the formula to find the artist's hourly rate, use this...
=VLOOKUP(C9,ARTISTS!$A$2:$F$15,3,FALSE). you can build this value into your formula