vlook up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help!
I am trying to do a comparison of employee #'s to find which ones are
missing from the prior month i.e. Sept to Oct. I have the standard template
with three tabs. They are labeled Oct, sept, Aug. The first for Sept - Oct
already has the formula Vlook (A2,sept!A:A,1,0)
How do I can change the vlook? I need to compare the same information
(compare Id #) for other months i.e. Aug to sept and July to augt. I am not
sure how to get the formula to apply to the entire whole column on the new
page for the next month. How can I get the formula and change over correctly
to receive an N/A . I need to figure out who is missing and it is a very
large group of employee. The employee ID # is in column a and the
information I am wanting it to check against is inc column E. Thank you
 
Help!
I am trying to do a comparison of employee #'s to find which ones are
missing from the prior month i.e. Sept to Oct. I have the standard template
with three tabs. They are labeled Oct, sept, Aug. The first for Sept - Oct
already has the formula Vlook (A2,sept!A:A,1,0)
How do I can change the vlook? I need to compare the same information
(compare Id #) for other months i.e. Aug to sept and July to augt. I am not
sure how to get the formula to apply to the entire whole column on the new
page for the next month. How can I get the formula and change over correctly
to receive an N/A . I need to figure out who is missing and it is a very
large group of employee. The employee ID # is in column a and the
information I am wanting it to check against is inc column E. Thank you
Click to expand...

This appears to be a question about the spreadsheet program Excel; you
have asked it in a newsgroup for a different program, Microsoft
Access. Please repost the question in an Excel newsgroup.

The functionality you're trying to get is very easy in Access, but I
hesitate to suggest moving your application from spreadsheet to
database unless you're willing to invest a substantial effort!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top