Try using this formula

=IF(VALUE(A1)=B1,C1,FALSE)

--
HTH

Bob Phillips

"haitch2" wrote in
message ...

Hi

Im using the if function, If example A1=B1 insert C1.

A1 (text field) has this formula in it =IF((I38=3),MID(H38,1,1)," ")
B1 (text field) =3
C1 (text field) = 0011

But every time i put the forumal =IF(A1=B1,C1,FALSE) it come up as
false even though they have the same value (all the field are text not
number as it will have letters in as well)

If i cange the 3 to an A the formual works fine.

this isnt the actual formual i want as im going to use a lookup table
but im just narrowing the problem down.

I hope this makes sense any help would be great. :)


--
haitch2
------------------------------------------------------------------------
haitch2's Profile:
http://www.excelforum.com/member.php...o&userid=27677
View this thread: http://www.excelforum.com/showthread...hreadid=474627