Match won't match until I click into a cell then hit enter

[Guest]

I have this which is fine
=T(SUBSTITUTE('I:\Everyone\WPSHARE\WIA Stuff\Caseload Info\[Caseloads Master 3-12-04.XLS]A'!C2," ","")
Have a macro to special paste the 9 digit value "123456789" into another cell which is fine

Have a match formula
=MATCH($E2,Exited!$G$6:$G$500,0

The problem I am having is that the match formula is not matching until I actually click into cell E2 and hit enter. Then it matches perfect. unless there is a way to match formula values and not have to do a special paste. All I know is that it should work and it doesn't. any help please?

 

[Frank Kabel]

Hi
try changing the formula to
=N(SUBSTITUTE('I:\Everyone\WPSHARE\WIA Stuff\Caseload Info\[Caseloads
Master 3-12-04.XLS]A'!C2," ",""))
or
=--(SUBSTITUTE('I:\Everyone\WPSHARE\WIA Stuff\Caseload Info\[Caseloads
Master 3-12-04.XLS]A'!C2," ",""))


--
Regards
Frank Kabel
Frankfurt, Germany

I have this which is fine.
=T(SUBSTITUTE('I:\Everyone\WPSHARE\WIA Stuff\Caseload Info\[Caseloads

Master 3-12-04.XLS]A'!C2," ",""))

Have a macro to special paste the 9 digit value "123456789" into another cell which is fine.

Have a match formula.
=MATCH($E2,Exited!$G$6:$G$500,0)

The problem I am having is that the match formula is not matching

until I actually click into cell E2 and hit enter. Then it matches
perfect. unless there is a way to match formula values and not have to
do a special paste. All I know is that it should work and it doesn't.
any help please?