Number vs Text

[felipe_mfds]

I have a string range1 insted of A1:C1, for instance.

My search cannot be completed because the formula is somehow unable to
search for the string, it searchs for the the text "range1", which is really
odd.

How can link the search to the cell without the ("") in the cell?

Thank you,

 

[Don Guillett]

A string referring to a range in a FORMULA will not work. You need to
hightlight the range and name it in the name box (to the left of the formula
box) or use insert>name>define>fill in the name>in the refers to box type in
the range reference. Then
=sum(range1)

In a macro
myrange=range("a1:c1")
for each c in myrange
do something
next

 

[felipe_mfds]

I've already named it and I cannot use the function SUM because the formula
is related to a LOOKUP function. Example:

LOOKUP(A1,B1) ;
B1 = "range1"
range1 = C1:F1

Get it?So I should probably used another function that doesn't change the
ranges properties. The question is, which function?

Tks

 

[Don Guillett]

GOT IT!!!!! Always nice to say what you mean the FIRST TIME. Get it?. Try
this.

=LOOKUP(a1,INDIRECT(b1))

 

[felipe_mfds]

Perfect!! I've a little rusty...

Ow, and sorry about that hehe...

Thanks very much!

 

[Don Guillett]

Glad to help