okiedokie2017
New Member
- Joined
- Sep 14, 2017
- Messages
- 14
Hello,
Normally if we have a table such as
<= 5 A
>5 B
>10 C
So if I have a number 6, it will give me B.
We all can use Vlookup for this range thing.
However, if I have an IF formula like below, I can not translate it into a Vlookup one:
=IF(A1>10, (A1-5)/200, IF(A1> 20, (A1-20)/400, IF(A1>30, (A1-30)/500, A1-30)))
How can I possible create a table so Ican do Vlookup because of the "A1" thing? As I need to apply this to the whole column of A, not just A1.
Please help?
Normally if we have a table such as
<= 5 A
>5 B
>10 C
So if I have a number 6, it will give me B.
We all can use Vlookup for this range thing.
However, if I have an IF formula like below, I can not translate it into a Vlookup one:
=IF(A1>10, (A1-5)/200, IF(A1> 20, (A1-20)/400, IF(A1>30, (A1-30)/500, A1-30)))
How can I possible create a table so Ican do Vlookup because of the "A1" thing? As I need to apply this to the whole column of A, not just A1.
Please help?