software

i want to change a number in one column and have it change to the referenced
table in the same spreadsheet.

example;
column M column R column ANcolumn AO
7 30,720.000 024,240.00
15 37,760.000 124,810.00
23 40,800.000 225,390.00

column AN and AO is a set pay schedule
i want column M to refer to column AN (years of service)
so when i plug in a 7(column M) i want it to pick up the number in AN and
pay in AO and have it change in column R.
thanks for your help

Even though I can't confirm by the numbers given, it seems that column M is
probably the years worked (for a given employee) and column an is the lookup
table for the number of years worked. If so, a vlookup in column r should
work. Something like (not tested

=vlookup(m1, $an$1:$ao$50, 2, false)

quot;Cindyquot; wrote:

gt; i want to change a number in one column and have it change to the referenced
gt; table in the same spreadsheet.
gt;
gt; example;
gt; column M column R column ANcolumn AO
gt; 7 30,720.000 024,240.00
gt; 15 37,760.000 124,810.00
gt; 23 40,800.000 225,390.00
gt;
gt; column AN and AO is a set pay schedule
gt; i want column M to refer to column AN (years of service)
gt; so when i plug in a 7(column M) i want it to pick up the number in AN and
gt; pay in AO and have it change in column R.
gt; thanks for your help