refer to columns

C

Cindy

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 AN column AO
7 30,720.000 0 24,240.00
15 37,760.000 1 24,810.00
23 40,800.000 2 25,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
 
K

Kleev

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)
 
Top