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?

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?

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"?

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"?

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?