Combine Values For Cell Name

Hi,
I was wondering why peoples are just reading my question with out trying to help me?

Thanks

Is this what you are trying to achieve:

In cell B4, enter this; IF(B4>1,"A"&VALUE(B4),"") and then copy it down as far as you need.

I wasn't entirely clear of your objective so I may have misunderstood what you're doing- reply if you need something else.

The formula you require is :
=INDIRECT(address)
which returns the value of the cell at the given address.

There is also the formula :
=ADDRESS(row,column,...)
Which can help you construct the address,
(but often it is just as easy to use the text funtions as you have).

Mark.

Re-reading your post and trying to interpret what you realy realy want,

The ROW() and COLUMN() functions might be useful.
ROW() gives you the row number of the cell
column() gives the column number of the cell.

for example If you are in CELL D6 then
=INDIRECT(ADDRESS(ROW()-3,COLUMN()+2))
will give you the value of the cell at F3.
The same formula in cell E7 will give you the value of the cell at G4.

does this help?

Mark.

Originally Posted by LondonVirus

Hi,
I was wondering why peoples are just reading my question with out trying to help me?

Thanks

Hello LondonVirus, I presume they either don't understand what you're trying to do or they understand but don't know how to achieve what you want. I think I know what you want to do. There are a few options, i.e.

=INDIRECT("A"&A3)

or (I prefer)

=INDEX(A:A,A3)

M aybe I didn't explain my self properly guys, I need to pick up the data from an other ****, now when I drag down to get the formula copied down I get:

=Sheet1!A2
=Sheet1!A5
=Sheet1!A8

I need it to copy down and say:

=Sheet1!A2
=Sheet1!A3
=Sheet1!A4
Even though each of the rows on the active **** are splitted in 3, bec ause on the other **** they are now and if I drag down the formula as it is I would be skipping 2 values at the time and collec t only once every 3 values...


Makes sence?


Say I have the names:

Mark
Luiggi
John
Paul

My coding now picks up

Mark
Paul...

Skipping 2 lines at the time...

By the ways thanks for trying to help me

Thanks Mark@Work , I will try that now, any other ideas are welcome

Try this formula in B4 copied down

=IF(MOD(ROW()-ROW(B$3)+1,3)<>2,"",INDEX(Sheet1!A:A,INT((ROW()-ROW(B$3)+5)/3)))

Could some one help me to join the values as I have said in my original post and use that as a cell name, something like

Way no1:

=(B2)

Way I want:

=("B"&B2)

Assuming that the value of "B2" is 2

Make sence?

I wanna join the 2 values, the letter "A" and the value of cell "B2" to create a cell n ame to refer to, I hope that makes sence

Thanks

Does my method as shown above in an earlier post do what you want?

What it will do is print the letter A and whatever number is contained in cell A4,A7 etc so for example you'll get the answers "A2", "A3", "A4" in cells B4, B7, B10.

Other methods demonstrated by Mark@work and daddylonglegs will print the content referred to by the cell address returned by their formulae- so for example, if A2 contains the word "Tom", this is what will be returned by their formulae instead of the actual characters "A2".

Hello?! I need help here, I have 30 minutes left to complete the project!

PLZ!

Originally Posted by LondonVirus

Could some one help me to join the values as I have said in my original post and use that as a cell name, something like

Way no1:

=(B2)

Way I want:

=("B"&B2)

Assuming that the value of "B2" is 2

Make sence?

I wanna join the 2 values, the letter "A" and the value of cell "B2" to create a cell n ame to refer to, I hope that makes sence

Thanks

English is obviously not your natural language which is causing some confusion.

=INDIRECT("B"&B2)
will work out as
=INDIRECT("B2")
which will be 2! (in other words the value of the cell B2)
In this case the result is exactly the same as =B2, but if B2 was (for example) 3 then the result would be the same as =B3.

Mark.

Originally Posted by LondonVirus

Maybe I didn't explain my self properly guys, I need to pick up the data from an other ****...

It's a dirty job, but someone's got to do it!