vlookup

[sue]

I have 2 questions ...I have created an employee supply
tracking spreadsheet with monthly worksheets within (ie:
jan, feb,mar...the last worksheet being a grand
total "year-to-date" ...using the vlookup on the year-to-
date to pull the monthly data together or when I drag down
the column to copy and paste the formula ...whenever, the
same employee name shows up ...excel2000 returns an
#N/A?
My 2nd question is how to create an easy formula to count
how many times excel sees the same name.

I hope these questions made sense ... I thank you in
advance!
sue

 

[Peter Atherton]

Sue

The answer to 2 is long winded but-
I created range names on sheets 1, 2 and 3. and typed the
name I looked for in cell A6

Then I typed the formula

=COUNTIF(names,A6)+COUNTIF(names2,A6)+COUNTIF(Names3,A6)

For question 1, is the range absolute e.g. $A$1:$A$26

if the range is copied the lookup range will change
otherwise. Using Range Names fixes this problem as named
ranges are fixed.

Regards
Peter

 

[sue]

Thanks Peter! this is great ...the formula I was using
was ...

=vlookup(a1,getdata!:$a$2:$c$50,2,0)

the get data worksheet is the one I use as my master
inventory sheet with 2 columns - First is ID# / 2nd is
Employee name

thank you so very much
sue

 

[sue]

Hi Lance ... thank you so very much for these ....I am
sorry I was unclear ...

the formula I was using is:
=vlookup(a2,getdata!:$a$2:$c$50,2,0)

I had created a master worksheet called getdata with 1st
column as ID and 2nd as Employee name ...

again I want to thank you...
sue