I have a lot of data in it, but I did not have any problem untill today when I was copying adding removing sheets. Suddenly it became very slow, so after entering each cell I have to wait like 2 seconds to go to another cell. Any tips? Thanx!
Ok I found it.
But now why this does not work:
If:
=ADDRESS(Match(32,A:A),1,4,TRUE)
returns the 'A13'
and
=Offset(A13,1,0,1,1)
returns the value of the cell A14,
why does
=Offset(ADDRESS(Match(32,A:A),1,4,TRUE),1,0,1,1)
does not return the value of the cell A14???
I am not very good with excel... Looking for a command that would search for a given value in a column and return a reference (in a form C32 for. eg.) of the cell that value is in.
How can i do that?
