| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range broken
Been using a dynamic range and a VLOOKUP for a long time on this
spreadsheet. Now the dynamic range is failing. No error message, just not working. The dynamic range "namelist" is on the sheet "Activity List" The formula is: =OFFSET(Activity List!$A$1,0,0,COUNTA(Activity List!$A:$A),2) This used to work, until I started fiddling with it yesterday. The VLOOKUP, on another sheet, is this: =IF(ISERROR(VLOOKUP(B1,namelist,2,FALSE)),"",VLOOK UP(B1,namelist,2,FALSE)) It's blank, so something is terribly wrong. Strange thing is, it was all working yesterday. Anyone see the problem? I mean, besides the user? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamic Range broken
your formula looks incorrect...cut & paste this...
=OFFSET('Activity List'!$A$1,0,0,COUNTA('Activity List'!$A:$A),2) note the single quote marks defining the sheet name "salgud" wrote: Been using a dynamic range and a VLOOKUP for a long time on this spreadsheet. Now the dynamic range is failing. No error message, just not working. The dynamic range "namelist" is on the sheet "Activity List" The formula is: =OFFSET(Activity List!$A$1,0,0,COUNTA(Activity List!$A:$A),2) This used to work, until I started fiddling with it yesterday. The VLOOKUP, on another sheet, is this: =IF(ISERROR(VLOOKUP(B1,namelist,2,FALSE)),"",VLOOK UP(B1,namelist,2,FALSE)) It's blank, so something is terribly wrong. Strange thing is, it was all working yesterday. Anyone see the problem? I mean, besides the user? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamic Range broken
On Tue, 14 Apr 2009 10:04:16 -0700, Patrick Molloy wrote:
your formula looks incorrect...cut & paste this... =OFFSET('Activity List'!$A$1,0,0,COUNTA('Activity List'!$A:$A),2) note the single quote marks defining the sheet name "salgud" wrote: Been using a dynamic range and a VLOOKUP for a long time on this spreadsheet. Now the dynamic range is failing. No error message, just not working. The dynamic range "namelist" is on the sheet "Activity List" The formula is: =OFFSET(Activity List!$A$1,0,0,COUNTA(Activity List!$A:$A),2) This used to work, until I started fiddling with it yesterday. The VLOOKUP, on another sheet, is this: =IF(ISERROR(VLOOKUP(B1,namelist,2,FALSE)),"",VLOOK UP(B1,namelist,2,FALSE)) It's blank, so something is terribly wrong. Strange thing is, it was all working yesterday. Anyone see the problem? I mean, besides the user? Thanks! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Broken: Set Cells in Range to 0 if blank | Excel Programming | |||
| dynamic range based on criteria, within a dynamic range, passed to a function | Excel Programming | |||
| creating a dynamic range based on criteria, within a dynamic range, and passing it to a function | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Deleting broken range names | Excel Programming | |||
Linear Mode
