Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
refer to columns
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
refer to columns
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) "Cindy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |