simple question

[SnowPlow]

I want to display a value from one of many cells Q1-395 in cell F13,
depending the value in cell E13

example: E13=60 so F13 displays whats in Q61


F13 = Q(E13+1)


How do I write this correctly?

appologize, if this could be found in a search, I tried but had no idea
what to search for

 

[Cutter]

Try the INDIRECT() function

In F13 type: =INDIRECT("Q"&E13+1

 

[Bob Umlas]

=INDIRECT("Q"&E13)

Bob Umlas
Excel MVP

 

[CLR]

=INDIRECT("Q"&E13+1)

Vaya con Dios,
Chuck, CABGx3

 

[Bob Umlas]

oops, right!

=INDIRECT("Q"&E13+1)

Vaya con Dios,
Chuck, CABGx3