Dynamic Range broken

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?
 
D

Dave Peterson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Range broken 2
Dynamic Range 1
Need some PWA help 0
Dynamic Range 2
XL Odd behavior interaction between dynamic range andSheet_Deactivate macro 0
Creating hyperlinks 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Defining a dynamic table_array for vlookup 9

Top