Referencing a cell in another sheet

[stefanvdw]

I am trying to write a formula by referencing a cell in another sheet. The result: my formula written out in full text and not the result of the formula. The cell which I refer to is a download from an add in application called easysoft.

Can you please help ?

 

[Andrew Poulsom]

What is in the cell you are referencing? And what is your formula?

 

[stefanvdw]

The cell I reference contains a value formatted as text from an ODBC operation. (Easysoft) The formula I use is a vlookup.

Thanks so far

 

[Wendy]

possibly. can you post that bit of code?

 

[stefanvdw]

Wendy,

I am not 100% sure of the code you refer to. The procedure I follow is to dump data via an ODBC (Easysoft Add in) download into excel. Then I reference the cell that is part of the download and the result is that my formula (vlookup) is returned to me in full text e.g. =vlookup(a9,a1:a10,6,false) while I need a result e.g. 99

 

[Andrew Poulsom]

? Tools, Options, uncheck Formulas in Window options on the View tab?

 

[stefanvdw]

Andrew,

This does not solve the problem. It has to do with the way the data is loaded via Easysoft (I think). When I copied the text result of the formula to another cell away from the easysoft download it worked. I copied the formula from there back to it's original cell and the result was #ref. By replacing the cell reference required the formula worked. The problem is that you can not copy the formula down because it gives the #ref error.

Another interesting thing is that when you go format cells for the cell where the formula is written , the format is text and not general etc.

 

[Andrew Poulsom]

I thought your easysoft download was on another sheet. So where is your easysoft data? And where are you writing your vlookup formula?

 

[stefanvdw]

Andrew,

The easysoft download is on another sheet in the same workbook. The formula that I am trying to make work is also on another sheet in the same workbook.

 

[Andrew Poulsom]

On 2002-09-16 09:36, stefanvdw wrote:
Andrew,

When I copied the text result of the formula to another cell away from the easysoft download it worked.

So what do you mean "away from the easysoft download"?

Post an example of what your easysoft data looks like and where it is, and the formula you are using and where it is.