Refer to another cell and grab that cell's referenced cell's contents

[kenshin]

Hi.

I am trying to write the formula that would grap the content of cell 2 which is referenced in cell 1.

how do i do that?

file is attached.

thanks.

like i want a7 to display Rob, b7 to display Luis, etc..

[norie]

Try this in A7 and copy across.

=INDIRECT("A"&A6) 

[Ger Plante]

Use

=indirect(B6) 

for example.

Ger

NB.... Too slow

[kenshin]

awesome! thanks a lot.