Using INDEX instead of OFFSET

I am trying to use the INDEX instead of OFFSET.

Attached is the file. Just can't figure this one out. I have all my pulldowns using offsets and working fine but need an INDEX function for one of my files.

Hi

Isn't that just:

=INDEX($F$26:$F$35,F39+1)

(this mimics your current OFFSET function. However, i don't see that this is really doing anything - what are you hoping to achieve?)

Richard

This works nice....

When I select something from Column A, I want the anything associated with that row to also be selected....
So if I select 3 on column A, then 3 from Column H and I will also show. Of course the 3 is only an example of my actual data.

Thanks again -

Right, the Offset and the INDEX are both incorrect in which case - you actually want:

=INDEX($F$39:$F$49,$F$26)

If you replace the values with alpha values, you'll see why it was round the wrong way.

Richard

I got it now!

Thanks