This is what I want to do
I have a cell A1 with the number 40
In another cell I want to use the number 40 to select a cell, something
like: =B40+234
Where 40 in B40 is the number typed in A1.
how do i do this please?
This is what I want to do
I have a cell A1 with the number 40
In another cell I want to use the number 40 to select a cell, something
like: =B40+234
Where 40 in B40 is the number typed in A1.
how do i do this please?
Try this:
=INDEX(B:B,A1)+234
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
<[email protected]> wrote in message
news:[email protected]...
This is what I want to do
I have a cell A1 with the number 40
In another cell I want to use the number 40 to select a cell, something
like: =B40+234
Where 40 in B40 is the number typed in A1.
how do i do this please?
Thanks, it works great, but I had to do it like this:
=INDEX(B:B;A1)+234
Can't tell from your OP what national version you're using.
Thanks for the feed-back.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<[email protected]> wrote in message
news:[email protected]...
> Thanks, it works great, but I had to do it like this:
> =INDEX(B:B;A1)+234
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks