Formula with FIND in the mix

[Aimee S.]

Halp!

Not sure if this is a Vlookup type formula with multiple conditions or an IF AND formula, but regardless, a FIND element is required.

What is the formula for:

If value in column A equals "OSP"
If value in column B equals 1
If value in column E contains the word "Camden"
Then pull value from column D where all of these conditions are met in the same row.

 

[VoG]

Possibly

=SUMPRODUCT(--(A1:A100="OSP"),--(B1:B100=1),--ISNUMBER(FIND("Camden",E1:E100)),D1:D100)

 

[Aimee S.]

When I try that I get

"You've entered to many arguments for this function"

I have Office 2010.

 

[taurean]

Probably this formula:
=IF(AND(A1="OSP",B1=1,ISNUMBER(FIND("Camden",E1,1))),D1,"Doesn't Match")

 

[VoG]

It seems to work here (Excel 2010)

Excel Workbook
	A	B	C	D	E	L
1	OSP	1		10	xCamdens	10
2	OSP	1		11	zzz
3	ASP	1		12	xCamdens
4	ASP	2		13	ggg
Sheet11

 

[Aimee S.]

Taurean-Thanks but the formula has to be able to search the entire columns which are 8000+ long and subject to change for the conditions I outline in order to find the single row that matches that description in the mix.

VoG- this time when I tried it it took Not sure what was up before. Thanks much.