Dynamic Range broken

  • Thread starter Thread starter salgud
  • Start date Start date
S

salgud

I've been using a spreadsheet with a dynamic range to do a VLOOKUP for
months now. Suddenly, it's broken, and I can't figure out why.
The formula is
=OFFSET(ActivityList!$A$1,0,0,COUNTA(ActivityList!$A:$A),2)
The sheet it's on is named "Activity List" on the tab and in the
"Properties" list.
The formula in the workbook on another worksheet is:
=IF(ISERROR(VLOOKUP(B1,namelist,2,FALSE)),"",VLOOKUP(B1,namelist,2,FALSE))
The dynamic range is "namelist".
Any suggestions?
 
There seems to be a mismatch between the worksheet names--one has that embedded
space character and the other doesn't.

Could it be as simple as that?
 
Back
Top