I have a rather frustrating problem that it seems others have had also but I have yet to find a solution that works.

I have simplified things below as I tend to give too much information.

Basicly I have one formula that looks at another and if the result of the first is 1 then the second returns "GREAT"

but if the result of the first is 2 then the second returns "BAD".

I have a formula that looks at the result of a formular on a different worksheet (in the same work book) and returns

a conditional result depending on the result of the first formula BUT its not working how it should?

I have two work books, one called Data.xls & the other called Results.xls.

Results.xls has a work sheet called 'Data_Grab' that uses formulas to pull specific data from Data.xls.

These formulas are fairly basic like =IF(ISBLANK([Data.xls]Track!$F$2),"",""&[Data.xls]Track!$F$2& "").

There is a second work sheet in Results.xls called 'Data_Sort' which does as its name suggests - it is meant

to take the data from the 'Data_Grab' using formulas to present it in certain ways.

It is this part that is not working.

Lets say the formula in Cell A1 of 'Data_Sort' grabs the number 1 from cell A1 of 'Data_Grab'...

Even the most basic formula like =IF(Data_Grab!A1=1,TRUE,FALSE) as it always shows FALSE when it should show TRUE.

Now if i manually type the number 1 in Cell A1 of 'Data_Grab then the formula works?

For what ever reason the formula in Data_Sort wont accept the result of the formula in Data_Grab??

I have tried creating a 'helper' column in Data_Grab and converting the value of A1 to text which didnt work

and I have tried converting the value to a number which also didnt work.

The only thing that worked was if I manually type in the number 1...

I can not find a way around this so any suggestions would be great as I can not procede any further, I am stumped.

Thanks.

## Bookmarks