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!

 

[snoopyhr]

<<sorry , Jeanie acting up >>

 

[snoopyhr]

Ok, trying agian, see if this what you are after....

Excel Workbook
	B	C	D	E
11	Employees		Name of interest	Result
12	Jim		Bud	yes
13	Tim		Jim	yes
14	Ray		Pam	yes
15	Pam		paul	No
16	Al		Sam	yes
17	Sam		steph	No
18	Bud		Tim	yes
Sheet1

 

[scottylad2]

If what I posted didn't work, can you be a bit more specific re your layout or requirments.

 

[DennyJV]

THANK YOU, THANK YOU, THANK YOU Snoopyhr... and Scottylad...! Snoopyhr's last post did the trick.

Guys- You Rock!

 

[snoopyhr]

You are welcome glad it worked