| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Offset References
I have an Excel sheet that displays products but because the products can be various states I do not want the product names on every row. eg: Product 1____ Sold _______ ____ Cancelled _______ ____ Ordered Product 2____ Sold _______ ____ Cancelled _______ ____ Ordered because the product names constantly change the product names are referenced from another sheet. So, how do I reference the product names to a list in another sheet so that i can just drag down the references? eg: _ Product_List_____Report_sheet_ Product 1____(link to) Product 1 Product 2 Product 3 Product 4____(link to) Product 2 etc -- gthull644 ------------------------------------------------------------------------ gthull644's Profile: http://www.excelforum.com/member.php...o&userid=23794 View this thread: http://www.excelforum.com/showthread...hreadid=374479 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert column without changing references | Excel Worksheet Functions | |||
| Cell references change when entering new data | New Users to Excel | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
| Cell References and External Data | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Threaded Mode
