software

I have a series of numbers that I want to shift. I can lookup the first
number in the series. Then to get the next number I want a formula which
looks at the first number and gives me the one next to it.

Just guessing at your configuration,

Number to lookup in Column A,
The quot;Nextquot; number is in Column B,
Enter lookup criteria in C1,

And try this:

=VLOOKUP(C1,A1:B100,2,0)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;axwquot; gt; wrote in message
...
I have a series of numbers that I want to shift. I can lookup the first
number in the series. Then to get the next number I want a formula which
looks at the first number and gives me the one next to it.
Thanks. But that formula looks up my no. in a row (eg A1) and instead of
giving me B1 (which is what i want) gives me A2

quot;RagDyeRquot; wrote:

gt; Just guessing at your configuration,
gt;
gt; Number to lookup in Column A,
gt; The quot;Nextquot; number is in Column B,
gt; Enter lookup criteria in C1,
gt;
gt; And try this:
gt;
gt; =VLOOKUP(C1,A1:B100,2,0)
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt; quot;axwquot; gt; wrote in message
gt; ...
gt; I have a series of numbers that I want to shift. I can lookup the first
gt; number in the series. Then to get the next number I want a formula which
gt; looks at the first number and gives me the one next to it.
gt;
gt;
gt;

No it doesn't !

The formula looks for the first number in Column A that matches the number
you entered into cell C1.
When it finds that number, it returns the number in Column B that is in the
same row as the quot;foundquot; number.

If A1 contained 100
And you entered 100 into C1
The formula would return the number in B1.

Isn't that what you asked?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

quot;axwquot; gt; wrote in message
...
Thanks. But that formula looks up my no. in a row (eg A1) and instead of
giving me B1 (which is what i want) gives me A2

quot;RagDyeRquot; wrote:

gt; Just guessing at your configuration,
gt;
gt; Number to lookup in Column A,
gt; The quot;Nextquot; number is in Column B,
gt; Enter lookup criteria in C1,
gt;
gt; And try this:
gt;
gt; =VLOOKUP(C1,A1:B100,2,0)
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt; quot;axwquot; gt; wrote in message
gt; ...
gt; I have a series of numbers that I want to shift. I can lookup the first
gt; number in the series. Then to get the next number I want a formula which
gt; looks at the first number and gives me the one next to it.
gt;
gt;
gt;