If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
adding three consecutive columns | Darin Gibson | Worksheet Functions | 1 | November 22nd, 2005 08:50 PM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Hiding columns and custom views problem | Bettergains | General Discussion | 2 | April 12th, 2005 11:48 PM |
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | foofoo | General Discussion | 1 | April 2nd, 2005 12:02 AM |
Adding rows in two dynamic columns | Justin Etheredge | Worksheet Functions | 0 | November 24th, 2003 10:27 PM |