Advanced formula question

  • Thread starter Thread starter Pete Poxton
  • Start date Start date
P

Pete Poxton

I need to reference a cell within a formula as below. I
could do it with Lotus, but Excel I can't.

Assume cell B5 has "b" in it.

Lotus;
&"+if(a1="&b5&"1,1,0)"
this formula would look at cell b5 for a column reference
and then use it to calculate the formula as below;
+if(a1=b1,1,0)

Excel;
="=if(a1="&b5&"1,1,0)"
When I try this all I get is the right thing but it shows
me the text formula and not the calculated value.
=if(a1=b1,1,0)

Any Ideas?
 
This works, thanks a lot!.

But if I copy the formula down, I would have to incrament
the "1" in each cell. Is there a way to have this behave
as a normal formula, or do I have to build it it manually?
 
Hi
if you start in row one with this formula try
IF(A1=INDIRECT(B5 & ROW()),1,0)
copy down
 
You have solved my problem!

Thanks.
-----Original Message-----
Hi
if you start in row one with this formula try
IF(A1=INDIRECT(B5 & ROW()),1,0)
copy down

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Back
Top