Dropdown list linked to a formula

**D_N_L** · 11-18-2011, 04:55 AM

Hi all,

I think this is probably really simple but I can't work it out! I have attached a workbook.

Basically, whenever one of the 3 names is selected in cell B8 I want the sum of their scores to appear in cell B9. So if I choose Dan then '10' appears in cell B9. Any ideas?

Thanks!!

**teylyn** · 11-18-2011, 05:06 AM

Hello,

try

=SUM(INDEX(B2:D4,MATCH(B8,A2:A4,0),0))

cheers,

**Fotis1991** · 11-18-2011, 05:06 AM

Hi

INDEX&MATCH, is what are you looking for.

Pl see the attachment.

**D_N_L** · 11-18-2011, 05:19 AM

Hi Teylen,

Thanks for your help! It works great. I'm trying to accommodate the formula within the below formula (which a fellow member kindly provided) but don't know where to start! Can you help me?

Please Login or Register  to view this content.

The above code is entered with Ctrl+Shift+Enter. The cell where my dropdown list is in is cell B56.

Thanks for any help you can provide.

**teylyn** · 11-18-2011, 05:33 AM

Well, you should have asked the whole question from the start.

Post a sample file with the formula in place and mock up the expected result.

**D_N_L** · 11-18-2011, 05:46 AM

Hi Teylen,

Many apologies, you're very right. I have created a new thread called 'Dropdown' with an example workbook. Apologies, I did this before seeing your reply.

Thanks for your help so far! I shall try to stick to protocol form now on.