Nesting 'if' statements...

[DennyJV]

Here's a much shortened version of my spreadsheet... where the numbers are meaningless...

jim 100 400 600
jim 200 300 800
jim 150 250 350
pam 100 200 300
pam 100 200 300
tim 200 300 400
tim 400 500 600

jim and pam are just 2 of the 17 employees in the Cash Applications group and I need to write a formula that I can put in column 'D' that will search 'A1', compare it to a list of employees in Cash Apps and return 'something' ('Cash Apps' maybe?).

I'm exhausted searching the database, any help would be greatly appreciated.

Thanks!

 

[VoG]

Your question is unclear to say the least. Perhaps you mean VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[DennyJV]

Maybe it IS a VLOOKUP that I need but I need help writing it and Contextures.com keeps freezing my comp when I try to open it.
But we'll try it again...

jim 100 400 600
tim 200 300 800
ray 150 250 350
pam 100 200 300
al 100 200 300
sam 200 300 400
bud 400 500 600

Jim, Tim and Pam are is the CA Dept. I need to write a formula that I can copy down 4k some lines to return me a 'Yes' or a 'No' as to whether they are in the department so that I can then 'bubble' them up to the top with a 'sort' and do some calculating on their lines.

Is that a bit clearer?

Thanks.

 

[rguy84]

What determines an employee is in CA?

 

[DennyJV]

I have a list of employees on a seperate sheet (about 17) that are in the CA Dept. Ray, Al, Sam & Bud were not in CA.

 

[rguy84]

Yup this smells like vlookup, try: http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

 

[scottylad2]

Are you just wanting a solution to say Yes they are in the dept, or is the column that contains the employees something you want to sum.....say for instance a cell where you can type a name and have a sum total of all the cash they've processed

 

[DennyJV]

Just to return a yes or no... I want the formula to look into a cell, if the name in that cell matches one from a list on another spreadsheet- I want it to say Yes.

I checked that VLookup site and am even more confused...

 

[scottylad2]

maybe this

Excel Workbook
	C	D	E	F	G	H	I
3	Employees					Employee	Present
4	Jim	100	400	600		Bud	yes
5	Tim	200	300	800		Jim	yes
6	Ray	150	250	350		Pam	yes
7	Pam	100	200	300		paul	no
8	Al	200	100	300		Sam	yes
9	Sam	200	300	400		steph	no
10	Bud	400	500	600		Tim	yes
Sheet1

this needs to be entered with Ctrl + Shift + Enter not just enter

 

[DennyJV]

Thanks but it still isn't working...