Data reference in Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

This might be really simple but I dont know how to do it.
I am trying to create a formula based upon the data entered in the first column of the same row

For example the data entered in B1 is "Hi" and in C1 is "Hello". SO i want to create a formula in the 9th Column which in effect is =Hi!F3! and =Hello!F3!.

I dont want to hard code it as in the next row the name could be anything else

Can someone tell me how to do this

Thanks in Advanc
-JJ
 
Hi Jjj

=INDIRECT(B1&"!F3")

--
HTH. Best wishes Harald
Followup to newsgroup only please

JJJ said:
Hi,

This might be really simple but I dont know how to do it.
I am trying to create a formula based upon the data entered in the first column of the same row.

For example the data entered in B1 is "Hi" and in C1 is "Hello". SO i want
Click to expand...
to create a formula in the 9th Column which in effect is =Hi!F3! and
=Hello!F3!.
 
Hi
do you want to create a dynamic cell referecne?. If yes use INDIRECT.
e.g.
=INDIRECT("'" & B1 & "'!F3)
to return the value for cell F3 from the sheet entered in cell B1
 
Hi Harald
I would always include the apostrophes in the INDIRECT function. Would
be more robust :-)
So I would use
=INDIRECT("'" & B1&"'!F3")
 
Harald & Fran

Guys u are good... I am not a Excel guy and was trying to do this and was going mad after the work I do and coudnt do this small thing

But this is coo

Thanks Guy

-JJJ
 
Frank Kabel said:
Hi Harald
I would always include the apostrophes in the INDIRECT function. Would
be more robust :-)
Click to expand...

Right you are. Without them there's problems with spaces and other odd
characters in the sheetnames. Sorry & thanks.

Best wishes Harald
Followup to newsgroup only please
 
Back
Top