| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can I use information from another sheet modify it, into a formula
How can I do the following:
a b c 1 Rank Ticket # Name 2 =teams!B2 =Sheet1!A10 =Names!T62 3 =teams!B3 =Sheet1!B10 =Names!T17 4 =teams!B4 =Sheet1!C10 =Names!T6 Sheet 1 is a list of random numbers. Names are the names associated with the random numbers and Rank is a constant. What I would like to do for the names column is a formula something like this: =Names!T(contents of corresponding column before + 1) in other words: =Names!T(sum(B2+1)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help!! using sheet 1 information to change information on sheet 2 | Excel Worksheet Functions | |||
| checkbox, then taking information from one sheet to another sheet | Excel Worksheet Functions | |||
| Formula for automatically entering information from a master sheet | Excel Discussion (Misc queries) | |||
| need to modify a macro to prevent it from executing if in wrong area of the sheet | Excel Discussion (Misc queries) | |||
| How do I modify row column format of Excel sheet? | Excel Worksheet Functions | |||
Threaded Mode
