Hi,
I am looking for a solution to this problem, which I think is pretty challenging. (Ideally I would like to have it sorted out without VBA or the least amount of code)

I have a lookup table like this

CityID City
1 London
2 Rome
3 Venice
4 Paris
...
....

1) Part 1

if cell A1 contains =2, the cell will display Rome,
if cell A2 contains =4, the cell will display Paris and so on
This of course should be only for a fixed Range of cell.

2) Part 2
I would like to have for each cell a combo box that (kind of Validation List)

Combo box displays Rome, Cell Value = 2
Combo box displays Venice, Cell Value = 3


Thanks

arguros