copy based off another cell

**villigeidiot** · 03-10-2010, 03:36 AM

Hello all,
I made a code that would tick a cell to make it react like a checkbox. I would like a function or code so that when i tick a cell in a range of cells the text i have in the cell to the left of the one i ticked gets copies to another cell. hopfully i explained that well enough.

**Kafrin** · 03-10-2010, 10:50 AM

If A1 is the cell with the text already in it, A2 is the tick box cell and A3 is where you want the text to be copied to, you need to put this formula into A3:

=IF(A2=True,A1,"")

I'm assuming here that the tick box cell has values of True or False, if not then change the 'True' part to whatever your tick box cell equals when it is ticked.

**villigeidiot** · 03-10-2010, 03:15 PM

Kafrin,
First off thank you for your time, this works however I was looking more like a range. I attached the document. I want it to whenever i tick the cell by a person's name for 1st on the "Finals" sheet then the name "associated" with it goes into the cell below "1st" in the finals section in the "dashboard" sheet and the same for 2nd and 3rd.

P.S.- please do not laugh at some of my codeing in the document i am still learning

thank you again for your help.

**Kafrin** · 03-11-2010, 07:43 AM

OK, on your dashboard, in the cell under "1st" you need this formula:

=LOOKUP("a",Finals!E:E,Finals!B:B)

Then for 2nd, change E:E to G:G, and for 3rd change it to I:I.

This formula will look down the column (either 1st, 2nd or 3rd) until it finds an "a", then show the value in column B (the Name column) that's in teh same row. Note that it only finds the first tick, so if you have more than one person ticked (eg because of a tie) this won't show up. If yu need to handle this situation as well, post back and I'll have a look.