formula error

I managed to create a number of complex formulas, but I have a problem to get this problem solved. I have a cell with the most simple equation: =Adreslist!C2 The result is not a name (which is in Adreslist!C2), but I see the formula in the cell. What is the reason that this does not work? Also...

The strangest kind of error is happening - when I drag a cell containing a formula to the adjacent cell - the formula copies properly but the value that is displayed changes to the ACTUAL contents of the originating cell. For example, if I create a formula =PROPER(A2) in cell B2 and then drag to...

Why is it that sometimes when i enter data into a completly empty cell it shows the enterder formula as normal text ( i ask this after i have set the cel format to general ) i can set it to whatever format i want it still shows just as text ???? anybody !???

Ok, I'm stumped with an error while trying to add this formula to a list type data validation: Formula: "=IF(LEN(Prev)>0,StatusID,"")" Prev is a Name with formula =RC[-1] and StatusID is a Name range =dbStatus[StatusID] This is the error in Excel: "The list source must be a delimited list...

Hi All, I have this formula that works great in 2007 but I'm trying to save the file for 2003 and it wont work. Can someone please help me replace the iferror with something that will do the same get rid of my #n/a in this really long formula...

I have a file with multiple worksheets and I need to do vlookup of UPCs from 1 worksheet called 0723 and if it is null value then vlookup from another worksheet called productmaster. The formula I came up with is...