=INDEX(..) need help!

---------------------------
1 I 2c I 5a I 6d I.....
---------------------------
2 I 6g I 10s I 1k I.....
---------------------------
3 I 2d I 1f I 4c I.....

ssdxsasawdwd9

Originally Posted by MaxAlbertsson

Hello


if i have a set of cells, for instance A1:C3 with values in them that looks like this:

......A....B.....C.....d......
---------------------------
1 I 2c I 5a I 6d I.....
---------------------------
2 I 6g I 10s I 1k I.....
---------------------------
3 I 2d I 1f I 4c I.....


Then i want to use the INDEX function to copy maybe in a particular case now: row 3 and obtain this result from whishever cell i started the formula from:

#......#......#.....#.....
---------------------------
# I 2d I 1f I 4c I.............
---------------------------
# I I I......................

If im not totally offine i guess you have to this like this:
=INDEX(A1:C3;3;0)

But i cant get it to work, if i enter with ctrl_shift_enter array format it dosnt work either.

Someone out there with a better solution?

Greatful for good answeres

Thanks

Perhaps

=INDEX(A1,3,Column())

is what you are looking for.

(if your data starts at A1 with no headers etc.)

---