Excel 2003 with Reference error cause me a headache

R

RumpelDiPumpel

Hello,

i would call myself an ordinary Excel user who tries once a year to
write a formula. This time I wanna concatenate the value of several
cells. I use the values from one sheet, the formula is described on th
second one and looks like this:

=IF(AND(NOT(T(Value_Sheet!C2)="")
T(Value_Sheet!B2)="ConditionalValue");
CONCATENATE(T(F2);Value_Sheet!A2);"")

The goal is to create a "space" separated chain of values in cas
several conditions where met. One condition is that one cell in th
"value sheet" has a dedicated value. The second condition ensures that
neighbour cell has at least a value. Pretty simple huh? The resul
(-chain) should be recorded in the formula sheet. My Problem is that i
case all conditions where met as result a Reference error is shown.
don't know why, because the Cell "Value_Sheet!A2" has values in an
case which could be used.

My assumption is Excel 2003 with its limited functions cause thes
reference error. The formula should be valid. Do you agree ?

Cheers, Rumpe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Dealing with the error: unable to filter on excel hc home school 0
External cell reference between two excel worksheets both in One Drive 0
Word macro that can call cells out of Excel for a find and replace 0
I need to cut characters off of a list of text cells... 2
how to select contents from a col which lies in between other columns 2
Cause and Effect chart convertion 0
Nesting SUMIF 11

Top