Related:
- Loop through column and assign value
- Facebook login approval needed loop - Facebook Forum
- Login approval loop, little options ✓ - Facebook Forum
- Vba find column by name ✓ - Excel Forum
- Excel if cell contains word then assign value - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
2 replies
Hi DK,
I can think of two solutions, but both have a downside:
1. IF function. Downside: maximum of 7 criterias.
Only use when the number in column A doesn't exceed the number 7.
Put this formula in C1 and drag it down:
2.VLOOKUP function. Downside: create an extra table.
Use when column A exceeds the number 7 and there isn't any other solution available.
Use for example column G to input as much numbers as nessecary and put their counterpart in the column next to it like:
1 4
2 5
3 6
4 7
5 8
6 9
7 10
8 11
9 12
10 13
Then use the following formula in C1 and drag it down:
=VLOOKUP(A1,$G$1:$H$10,2)
Hope this helps,
Trowa
I can think of two solutions, but both have a downside:
1. IF function. Downside: maximum of 7 criterias.
Only use when the number in column A doesn't exceed the number 7.
Put this formula in C1 and drag it down:
=IF(A10=1,4,IF(A10=2,5,IF(A10=3,6,IF(A10=4,7,IF(A10=5,8,IF(A10=6,9,IF(A10=7,10,"")))))))
2.VLOOKUP function. Downside: create an extra table.
Use when column A exceeds the number 7 and there isn't any other solution available.
Use for example column G to input as much numbers as nessecary and put their counterpart in the column next to it like:
1 4
2 5
3 6
4 7
5 8
6 9
7 10
8 11
9 12
10 13
Then use the following formula in C1 and drag it down:
=VLOOKUP(A1,$G$1:$H$10,2)
Hope this helps,
Trowa