Excel lookup formula

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

Question

Creator

Topic
February 6, 2014 at 7:59 am #2135800

Excel lookup formula

Locked

by samtitus · about 8 years, 3 months ago

Tags: Windows

I need a formula to do the following

look up a name in column A1 on sheet1

then look up that name on sheet2 in column A1:A6

when it finds that name it need to look in column B to find a date, if that date matches January 2014 it has to look up the value in column c and add all the values it finds for that person in January 2014

This conversation is currently closed to new comments.
Creator

Topic

All Answers

Author

Replies
- February 6, 2014 at 7:59 am #2425121
  
  Clarifications 1391673544
  
  by samtitus · about 8 years, 3 months ago
  
  In reply to Excel lookup formula
  
  Clarification dummy post @ 1391673544
  - February 7, 2014 at 10:50 am #2425114
    
    Clarification
    
    by samtitus · about 8 years, 3 months ago
    
    In reply to Clarifications 1391673544
    
    URGENT – Please can someone assist me with my problem
Author

Replies

Viewing 0 reply threads

Start or Search

Start New Discussion

Procuring software packages for an organization is a complicated process that involves more than just technological knowledge. There are financial and support aspects to consider, proof of concepts to evaluate and vendor negotiations to handle. Navigating through the details of an RFP alone can be challenging, so use TechRepublic Premium’s Software Procurement Policy to establish ...

Recruiting a Security Analyst with the right combination of technical expertise and experience will require a comprehensive screening process. This hiring kit from TechRepublic Premium includes a job description, sample interview questions and a basic want ad that you can customize for your business to find, interview, recruit and hire the best candidates for a ...

Recruiting a DevOps engineer with the right combination of technical expertise and experience will require a comprehensive screening process. This hiring kit from TechRepublic Premium includes a job description, sample interview questions and a basic want ad that you can customize for your business to find, interview, recruit and hire the best candidates for a ...

Windows

Question

Excel lookup formula

All Answers

Clarifications 1391673544

Clarification

Software Procurement Policy

How to recruit and hire a Security Analyst

How to recruit and hire a DevOps engineer

How to recruit and hire a video game quest writer