| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling a formula down-need correct cell reference
Below is the formula I'm using to for one worksheet to match data with a
worksheet in another workbook, if data matches it references to a cell on that row, if it doesn't it returns false. On the master file when I fill the below formula down on the first A2:G2 increases while the others stay the same. How can I fix this so that they all increase when I fill down? Thanks =IF($A2:$G2='[worksheetname.xls]John Brown!$A$2:$G$2,'[worksheetname- John Brown-COPY.xls]John Brown!$H$2,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically filling in a formula in a cell | Excel Discussion (Misc queries) | |||
| Copy formula down a column does not use correct cell reference | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| filling information from one cell and filling another. | Excel Worksheet Functions | |||
| How is it that a cell can transfer the correct formula, but the w. | Excel Discussion (Misc queries) | |||
Threaded Mode
