reference cells to a non sequential cell list

**rob171171** · 03-22-2011, 07:48 AM

Hi

Im tyring to reference cells to a non sequential cell list as in the example below

Tab B - B2 reference Tab A - B3
Tab B - B3 reference Tab A - D3
Tab B - B4 reference Tab A - F3

**peterjuhnke** · 03-22-2011, 07:58 AM

rob. I think you need a bit more info, what do you mean by reference, what function are trying to perform. what do you expect to find as an aswer.
Regards
Peter

**martindwilson** · 03-22-2011, 07:58 AM

try
=INDEX(A!$3:$3,ROW(A1)*2)

**rob171171** · 03-22-2011, 08:09 AM

Many thanks Martin, You got it!
Thanks also Peter for your help.

**arthurbr** · 03-22-2011, 08:27 AM

Rob,

as you may have read this forum has certain rules, particularly those related to Thread Titles.

Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search.

I will adapt your title for you, using your OP.Please check this out in the future