Vlookup Help

Nathan87

New Member
Joined
Sep 24, 2014
Messages
2
Hello,

I am trying to do a VLookup that is proving to be more difficult than I had anticipated, and now I have hit a brick wall.

I will be as descriptive as I can in my issue.

I have a workbook with two tabs. The first tab is a summary sheet, and the second contains the data that the summary sheet is to pull from.

The data sheet contains a list of employees, and tasks that they have performed. The tasks are listed as columns, with a simple "Yes" or "No" as to if the task is complete. Note here that there are three different area's that each task can be performed, and that is in a column as well.

I want the summary sheet to do the following:
1) Look at the data sheet to see the last time the employee completed a task.
2) Look at the data sheet to tell me if ALL tasks are completed in the given area. (Three areas listed in three columns).

I have been using IF Vlookups, and can not seem to get this to work.

I need to Lookup to see 1) that the employee has completed a task for the specific area, then 2) let me know if ALL tasks have been completed. (First look up area name with a "yes" "no" response, then look up the area name and let me know if all tasks have been entered "yes" or if there are any "no"s)

I realize this is difficult to describe on here. But if anyone could help, it would be so helpful. I am able to email the sheet to you to look at.

Thank you soooo much!

I have included a link to a Google Sheet version of the sheet I am working with, but not sure if it will allow external collaboration.

https://docs.google.com/a/lafarge.c...rz6EwfZOBekgiz_XkRDIPmasFckc/edit?usp=sharing
 
Last edited:

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,871
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Platform
  1. Windows
The file needs permissions to access - please make it public.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,827
Messages
5,855,878
Members
431,771
Latest member
CoryMelth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top