Dynamic Range Not Working

B

Bob Phillips

Perhaps it should be

=OFFSET(Harvest!$A$2,0,0,COUNTA(Harvest!$A:$A),COUNTA(Harvest!$2:$2))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
T

Takeadoe

I created a named range called HarvestData.

In the refers to box I typed the following:
=OFFSET(Harvest!$A$2,0,0,COUNTA(Harvest!$A:$A),COUNTA(Harvest!$1:$1))

I hit ok.

If I go back into the "Define Name" dialog box and select the name
"Harvest" and have it point to the actual range in the worksheet, it
highlights cells A2:B20. The problem is, there are data in columns A
to N. Why is it not recognizing the rest of the columns? I discovered
this problem because I'm referencing column h in a VLOOKUP and it is
not returning data that I know is there.

What am I doing wrong here?

Your help is really appreciated.

Mike
 
J

JE McGimpsey

Your formula works fine for me, as long as I have data in row 1. Are you
sure you have data in each cell from A1:N1?
 
T

Takeadoe

First, thank you for replying. Second, I do not have data in every
cell from A1:N1. I do have data in A2:N2 though, which is actually my
header row. Is that the problem?

Mike
 
Top