| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
One File, many data (AB!, AC!, AD!, AE!) sheets, one report sheet.
The Data sheets have numerical lists in column E (column F is the "name" field) Report Sheet has one modifiable cell entry to populate the fields within itself. How do i manipulate a formula (to look at a specific sheet) by adding text to another cell? ie: Modifiable Cell: (let's say this cell is Report!B2) "AE034" Protected Formula: =VLOOKUP(RIGHT(B2,3),LEFT(B2,2)&"!"&"E:F",2,FALSE) (:doesn't work  i want to tell the protected cell to become =AE!F34 and naturally display the "name" within the data sheet AE. Questions for excel are generally more difficult to ask than the actual formulae!!! |
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro Fill Cells With Formula; Conditional To Seperate Column | CVinje | Microsoft Excel Misc | 3 | 4th Jul 2009 01:17 PM |
| formula using up 2 10 cells of $ 2 seperate & = $ amt | =?Utf-8?B?Y2FuZGFob3Bl?= | Microsoft Excel Worksheet Functions | 6 | 31st Mar 2006 06:39 PM |
| how do I create a formula to seperate name into two cells (last, . | =?Utf-8?B?am9iYnk1NQ==?= | Microsoft Excel Misc | 2 | 13th Jan 2005 05:00 AM |
| Using the results from two seperate cells to create cell reference | DarrenWood | Microsoft Excel Worksheet Functions | 2 | 14th Nov 2004 10:35 PM |
| Using the results from two seperate cells to create cell reference | DarrenWood | Microsoft Excel Worksheet Functions | 0 | 14th Nov 2004 10:20 PM |
