Refrencing
 

I have the problem. I have sheet with some data organized in few columns
and I want to reference values from that €œtable€� in dependence of the
first value in row.
Is it possible?

Refrencing
 

Have a look at the MATCH worksheet function

--
Don Guillett
SalesAid Software

"John Smith" wrote in message
...
I have the problem. I have sheet with some data organized in few columns
and I want to reference values from that "table" in dependence of the first
value in row.
Is it possible?

Refrencing
 

Hi John,

Look at the Offset Property in VBA help.


---
Regards,
Norman



"John Smith" wrote in message
...
I have the problem. I have sheet with some data organized in few columns
and I want to reference values from that "table" in dependence of the first
value in row.
Is it possible?

Refrencing
 

Don Guillett wrote:
Have a look at the MATCH worksheet function



This is promising...
And how could I do referencing on field when I now that is "A5"?

Refrencing
 

If A1 contains the string "A5" and you want to display or use the value in
A5 in another cell, then in the other cell, put in the formula

=Indirect(A1)

--
Regards,
Tom Ogilvy


"John Smith" wrote in message
...
Don Guillett wrote:
Have a look at the MATCH worksheet function



This is promising...
And how could I do referencing on field when I now that is "A5"?