Using Multiple IF Statements

[ddhawks]

Hi Everyone!

I'm working on a spreadsheet where everyone's work hours are tied to the project he or she is working on. For example, I have the name of the person in Column D, and Column R is the hours billed to the job. The hours billed to the job comes from a list at the bottom of the spreadsheet which is linked to another spreadsheet and is updated monthly. This data is found in Column B, Rows 40-59, with each row the number of hours each person worked.

Here is the formula I'm using: =IF(D4="Sean Mahoney",B44,IF(D4="Brad Stabenow",B45,IF(D4="Nicole Anderson",B41,IF(D4="Matt Huderski",B43,IF(D4="Shea Groom",B42,IF(D4="James Sherry",B52))))))

The very first row under PM Hours Billed to Jobs is correct. None of the others are. Is there a better formula to use? I copied and pasted my spreadsheet below because I couldn't figure out to insert a link. If anyone can help me out, I'd greatly appreciate it.

Thank you!
Darleen

Job #	Closed	Job Name	Project Manager	Superintendent	PM Hours Billed To Jobs		Supt Hours Billed To Jobs
2016-474		RMR US Treasury TI	Sean Mahoney	James Martin	5.00		10.00
2016-495		CRMC Dialysis Addition	Brad Stabenow	Dan Ozborn	7.00		12.00
2016-496		Swope OBGYN & Pediatric	Nicole Anderson	Troy McKitrick	4.00		11.00
2017-497			Sean Mahoney	Derrick Shanks	8.00		17.00
2017-509			Matt Huderski	James Sherry	8.00		13.00
2017-511			Matt Huderski	Troy McKitrick	9.00		11.00
2017-513			Shea Groom	John Alexander	9.00		8.00
2017-518			Nicole Anderson	James Sherry	9.00		13.00
2017-520			Sean Mahoney	Jake Lawson	13.00		15.00
2017-523			Sean Mahoney	James Martin	14.00		10.00
2017-527			Nicole Anderson	Mitch Welty	12.00		14.00
2017-529			Brad Stabenow	Gus Purdum	17.00		20.00
2017-531			Matt Huderski	Aaron Hankammer	16.00		7.00
2017-532			James Sherry	James Sherry	0.00		13.00
2017-533			Shea Groom	John Alexander	17.00		8.00
2017-534			Nicole Anderson		17.00
2017-535			Sean Mahoney	James Martin	0.00		10.00
2017-536			Matt Huderski		0.00
2017-537			Shea Groom		0.00
2017-538			Brad Stabenow		0.00
2017-539			Matt Huderski		0.00
2017-540			James Sherry	James Sherry	0.00		13.00
2017-541			Shea Groom	Aaron Hankammer	0.00		7.00
2017-542			Shea Groom	Aaron Hankammer	0.00		7.00
2017-543			Matt Huderski	Troy McKitrick	0.00		11.00
2017-544			Nicole Anderson		0.00
2018-545			Nicole Anderson	James Sherry	0.00		13.00
	Hrs to Jobs
Don	1.00
Nicole	2.00
Shea	3.00
Matt	4.00
Sean	5.00
Brad	6.00
Aaron	7.00
John	8.00
Bob	9.00
James M	10.00
Troy	11.00
Dan	12.00
James S	13.00
Mitch	14.00
Jacob L	15.00
Jeffrey M	16.00
Derrick	17.00
Jacob A	18.00
Jeff P	19.00
Gus	20.00

<tbody>
</tbody>

 

[Simon4s]

You would use a Vlookup
=vlookup("NAME",TABLE,column number that you wish to return,0)

 

[ddhawks]

You would use a Vlookup
=vlookup("NAME",TABLE,column number that you wish to return,0)

Simons4s,
Can you please explain this a little more? I'm not familiar with Vlookup.

Thank you!

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F	G	H
3	Job #	Closed	Job Name	Project Manager	Superintendent	PM Hours Billed To Jobs		Supt Hours Billed To Jobs
4	2016-474		RMR US Treasury TI	Sean Mahoney	James Martin	5		10
4b

Cell Formulas
Range	Formula
F4	=VLOOKUP(D4,A33:B52,2,0)
H4	=VLOOKUP(E4,A33:B52,2,0)

N.B. The names must be consistent i.e. The list with the hours would have to include both first and last names.

 

[ddhawks]

Worksheet Formulas Cell Formula F4 =VLOOKUP(D4,A33:B52,2,0) H4 =VLOOKUP(E4,A33:B52,2,0) <tbody> </tbody>

<tbody>
</tbody>

N.B. The names must be consistent i.e. The list with the hours would have to include both first and last names.[/QUOTE]

This is EXACTLY what I needed. Thank you so much for your help!