| 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 |
| 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) | |||
Threaded Mode
