Designated Amountsa

Hello, I am trying to figure out how I can place a number in Cell A1 and then in Cell A2 a designated number appears.

Example...

(Cell A1) I place the number 10 and in (Cell A2) the number 450 will appear.

I want to do this for 10 numbers.


Thanks for your help in advance..

Kory

Hi Kory,
you need to specify how the numbers relate, you can use an IF statement to place in A2, "=if(A1=10,450,"")" this only deals with one number if you have many numbers then you would use 'IFS', "=ifs(A1=10,450,A1=11,451,A1=12,452) you can repeat this for how many sets of numbers you have....
Without knowing your requirements more this would be my advice.

Thanks

Leigh

Hello and welcome to the forum.

You can also build a lookup table with the entry number in one column and the "designated number" in another column.

Then use a VLOOKUP formula in cell A2 to look for A1 in the first column and return the matching value in the second column.

Thanks.. it says #NAME? when I tried the =ifs(A1=10,450,A1=11,451,A1=12,452)

What does this mean?

The IFS function is only available with an Office 365 subscription.

You would have to use nested IF functions if you want to go that route.

Since there are 10 numbers, I would personally use a lookup table instead.

What about a drop down menu in A1 that will put the designated number in A2?

Do I need a subscription for that also?

Thanks

You can do that with data validation in A1 and a formula in A2.

You only need a subscription to use certain functions (none of which are "needed" in my opinion).

If it's a drop down in A1, only values that are available could be selected, so you could use something like this in A2:

=LOOKUP(A1,{10,11,12},{450,451,452})

Worked Great thanks everyone...

Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.