Trying to make data auto-generate into a value in another cell

[Overdahill]

Hi

I've created a dropdown menu with different options, I'm trying to have the cell next to this generate a number based on what you select in the dropdown menu

I've attached an excel I've been trying to do it with, I can get it to work with 2 options however it's proving difficult after that.

On the example you'll see I've done it with 2, but after that it says #VALUE!

Any assistance would be much appreciated!

Thank you

[PaulM100]

in C3:
=IF(B3="UP","1",IF(B3="DOWN","2",IF(B3="RIGHT","3",IF(B3="LEFT","4"))))

"=IF(B3:B4="HERMES","1")" What logic are you trying to apply here?

[samba_ravi]

try
=IF(B4="UP",1, IF(B4="DOWN",2, IF(B4="RIGHT",3,4)))

[Overdahill]

Thank you very much!

I'm trying to total them at the bottom if it's possible.

For example if we have 2 lefts that = 4 each, this will total 8 at the bottom, is this possible?

Again, thanks so much for your help.

[PaulM100]

Either one of these two:

=SUMPRODUCT(($B$3:$B$6=$B10)*$C$3:$C$6)

=SUMIF($B$3:$B$6,$B10,$C$3:$C$6)

Change the ranges as desired.

[Mazzaropi]

Overdahill, Good morning.

The issue is already very well resolved with several solution options.

I present my 2cts of collaboration here.

C3 -->

Please Login or Register  to view this content.

Copy it down.

C10 -->

Please Login or Register  to view this content.

Copy it down.

I hope it helps.

[Overdahill]

Hi Paul
Thank you for your help.

I have done this, however I am receiving a 'FALSE' message when I do not select UP in B3 (using your example above)

Do you know why? B3 for example has more than UP, DOWN, RIGHT, LEFT in the dropdown list, as there is data in the dropdown list that also applies to another cell. Could this be the issue?

[JohnTopley]

I tried the formula with more options in the Drop down and the SUMIF certainly worked OK.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.