Formula for an other cel

**Warre** · 06-22-2022, 08:58 AM

Hello so i want to do something i've never done (as a excel user) i've been looking in this for some hours but i can't find anything.
What i want to do is have a 'list' (just the names of things in cels under each other, and then the cel right to it a number) where i can change the number using this [look picture]
"i.imgur.com/vJSJq7P.png"

So i select the name with the list and use the two arrows on the right to change the value up and down. So for example using Big bertha has a value rn of 6 i select "big bertha" in the list where also other names are listed and change the value using the arrows. But i also want an other name changed. so i'll do the same thing. I want then that the amount thats in this sort of list "i.imgur.com/yLITj97.png" of big bertha change to 7 and when i select and other name it'll keep the change of big bertha and i can change the others.

If anyone has an aswer to this please give me help, i wanna figure this out. If you have more question pls ask so i can give you more info of how i want it to be.

Thank you.

**AliGW** · 06-22-2022, 09:05 AM

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

**Warre** · 06-22-2022, 09:27 AM

Hello AliGW what do you mean with that?

**AliGW** · 06-22-2022, 09:51 AM

Did you read the instructions I mentioned? Here they are:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

**Warre** · 06-22-2022, 09:56 AM

Here is the example i used. I think it'll work like this right?

**AliGW** · 06-22-2022, 10:00 AM

Is this what you want?

In D2:

=INDEX($B$2:$B$45;MATCH(D1;$A$2:$A$45;0))

**Warre** · 06-22-2022, 10:28 AM

it doesn't work for me, when i put it into D2 it says #naam (#name in english ig) i am dutch so it may be that something in the formula is not dutch? but i can't find the subsitude of it

**Warre** · 06-22-2022, 10:41 AM

it seems that when i press the arrows the formula dissapears and the new number doesn't replace the old one? How do i do that?

**AliGW** · 06-22-2022, 10:48 AM

In Dutch:

=INDEX($B$2:$B$45;VERGELIJKEN(D1;$A$2:$A$45;0))

https://en.excel-translator.de/translator/

How do i do that?

Why do you need the selector box at all? If you make cell D1 a drop-down list, they can choose from there and it will all change automatically.

**Warre** · 06-22-2022, 10:52 AM

Dang i was over thinking it, but how do i change the number then? and how do i save the changed number to the big list next to it?

**AliGW** · 06-22-2022, 10:55 AM

No idea what you mean. I've read your opening post again and confess I have no clue what you are actually trying to do here. Sorry.

**Warre** · 06-22-2022, 11:16 AM

like i mean, i have a big list where i put info in it right its the list on the left. Then i have a choosing thing where i can choose one of teh names out of the list and display the number thats next to it under it. Then i need to be able to change that number by like 1 up or down or so and get that new number to replace the old number in the big list. if you know what i mean?

**AliGW** · 06-22-2022, 11:26 AM

Yes, I understand now.

You will need VBA for this. Shall I move the thread for you?

**Warre** · 06-22-2022, 11:41 AM

That would be nice of you, and whats VBA?

**AliGW** · 06-22-2022, 11:44 AM

Visual Basic for Applications - code. It will be OK as long as you aren't running your workbooks in a browser. If you are, then you are not going to be able to do what you want. I'll move the thread now.

**Warre** · 06-22-2022, 11:53 AM

do you mean excel? i use excel as an application on my pc i don't use it on browser

**AliGW** · 06-22-2022, 12:06 PM

Yes and that's fine, then. Now you'll need to wait for a VBA expert to take a look.

**Warre** · 06-22-2022, 12:10 PM

ahaha ok i'll wait thank you very much, even tho we didn't find it i'll thank you for your effort :>

**AliGW** · 06-22-2022, 12:13 PM

No, however we did find out what you wanted, and that's a big step!

I have put out a call for help to the community.

**Warre** · 06-24-2022, 03:16 PM

Thank you but no one has come and look at it i think...

**AliGW** · 06-24-2022, 05:31 PM

There have been 135 views - a good number of these will gave been after the thread was moved. So it seems that nobody can help on this occasion.

**davesexcel** · 07-10-2022, 08:49 AM

Check it out.

Hard to explain if you haven't worked with vba.
Open the workbook and enable macros
select the name
click the up or down arrows to adjust amounts.

**Warre** · 07-16-2022, 06:28 AM

omg thank you so much, i will use this well

Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Re: Formula for an other cel

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula SUM(A+B) - Copy formula to SUM(D+E), SKIP C. Automatic formula

Bookmarks

Bookmarks

Posting Permissions