Conditional formating/data tables

[taylor425]

I am unsure how to make this formula work for me. The example ia:

I have a list of values in A1 that range from 1-25 that can be selected.

In B1 i need a formula that will make B1 a certain value based off what number is in A1

Example:

A1. B1
1. 1
2. 2
3. 5
4. 12

In a1 the user can select a number between 1-25. Once selected B1 automatically changes to the corresponding number.

Ive tried play with =if functions and others with no luck. Any help wpuld be appreciated.

 

[seekerarcane]

Use this one in B1 and drag it down;

=IF(OR(ISBLANK(A1),A1<=0),"",IF(AND(A1>=1,A1<=25),50,100))

and like wise.....

 

[taylor425]

This didn't work. Just came up as error.

 

[taylor425]

In a1 there is a drop down menu with value ranging from 1-25. When I select 1 in the a1 cell. I want b1 to say 1.

But when I select 3 in a1, b1 needs to say 5. Each value 1-25 will have a different value associated with it in b1.
No math I believe is needed

I literally just need 1 =1, 2=2,3=5,4=10
Where the first digit is in a1 and second is b1. I'll list all the values and maybe that will help.

A1. B1
1. 1
2. 2
3. 5
4. 12
5. 20
6. 30
7. 45
8. 60
9. 85
10. 100
11. 120
12. 150
13. 180
14. 250
15. 340
16. 500
17. 700
18. 900
19. 1200
20. 1500
21. 1800
22. 2100
23. 2400
24. 3000
25. 4500