Index Referencing problem

[orabbit]

I can't figure out why the this function will not work, any ideas?

=INDEX('Form Responses 1'!B(INDEX('Invoice'!B5)))

what I want to have happen is whatever number is in B5 will be the number index references.

Like if B5 contained 2 it would end up looking like this: =INDEX('Form Responses 1'!B2)

And the second function above works fine.

Also obviously there are two different sheets

[Solved]

[Jonmo1]

Try

=INDEX('Form Responses 1'!B:B,'Invoice'!B5)

[Craig K.]

*disregard this post*