Related:

- Loop through column and assign value
- Fruit loop studio - Download - Musical production
- Game loop - Download - Android emulators
- Facebook login approval needed loop - Facebook Forum
- How to convert row to column in notepad++ ✓ - Excel Forum
- Windows xp boot loop ✓ - Windows XP Forum

## 2 responses

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