#### ExcelChampion

##### Well-known Member

- Joined
- Aug 12, 2005

- Messages
- 976

If I type 3 in A1 the formula returns 1. If I type 1 in A1 the formula returns 2. If I type 2 in A1 the formula returns 3.

I want the opposite. If I type 2 in A1 it returns 1. If I type 1 in A1 it returns 3. If I type 3 in A1 it retunrs 2.

Can't get my head around it. Any help is appreciated.

PPT.xls | ||||||
---|---|---|---|---|---|---|

A | B | C | D | |||

1 | 3 | |||||

2 | ||||||

3 | 1 | |||||

Sheet1 |