Does anyone know if you can have use cell data in a formula or function.

Basically... If a cell = 5... i need another function to look at data in
A5... however... if the cell = 6.. i need it to look up A6....

any ideas...?