| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing part of cell reference in INDEX - MATCH formula
Think I lost you there. The variable cell is defined in the formula as: G$1,
which means when you copy it across it'll change to H$1, I$1, etc which is as per your intents as posted earlier? -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "HebbeLille" wrote: Hi, and thanks for the effort. You are quite right that it works for this particular cell, but when the formula is like this, it doesn't automaticly change when copying in the spreadsheet. The formula now is locked to cell G1. The purpose of the formula is to be locked to row 1, and automaticly change the column G to H, I, J, K and so on. Thanks for helping, appreciate if there is a solution of the last tricky bit.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a changing cell reference as part of a workbook name 2 link | Excel Discussion (Misc queries) | |||
| INDEX - MATCH - OFFSET By Reference | Excel Worksheet Functions | |||
| Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
| Using the result of formula as part of reference to a cell in form | Excel Worksheet Functions | |||
| Index match formula works in for one worksheet reference but not another | Excel Worksheet Functions | |||
Threaded Mode
