Bizarre column and row functions behaviour

J

jcollot

I have a spreadsheet with data that i get from various sheets an
concatenate in order to create a range for use with indirect.

In an array i need a value to change automatically depending on row an
colum... If I am say in F3 and use column() the result is 6, row() give
me 3... No problem

Up to now I was referencing cells (row 100) in which I ha
incrementally put the values B100=A100+1.... All this in a formula o
the type :

=INDIRECT(CONCATENATE("Data!",T(Data!A$192),"$",F$100)

To clear things out this could give me =INDIRECT(DA$6)

Now if I replace the F$100 with COLUMN() this fails... F$100 contain
value 6, COLUMN() on its own returns 6. Any ideas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate entry in a column/row 14
Using SUM(INDIRECT()) 2
using row number or column letters in formula 6
Return last row no. of column with blanks at top 7
Index/Match Functions to Return Concatenated Response 4
Using Indirect for conditional Formating 3
Find text in N columns and one Row 1
Excel VBA macro, search - accumulate - delete original 0

Top