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?
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
[email protected]
"John Smith" <[email protected]> wrote in message
news:[email protected]...
>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?
Hi John,
Look at the Offset Property in VBA help.
---
Regards,
Norman
"John Smith" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:%[email protected]...
> 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"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks