Match name and multiply

[nparrillo]

If name in column E matches name in Colum B and has a "Y" in Column C, then multiply Column F by (-1), if "N", multiply by (1).
Solution would be in Column G

 

[alansidman]

Book4
	B	C	D	E	F	G
2	Name	(Y/N)		Name	Count	Other
3	sally	Y		sally	2	-2
4	Mark	N		Ma rk	3	3
Sheet1

Cell Formulas
Range	Formula
G3:G4	G3	=IF(AND(B3=E3,C3="Y"),F3*-1,F3*1)

 

[nparrillo]

Book4
	B	C	D	E	F	G
2	Name	(Y/N)		Name	Count	Other
3	sally	Y		sally	2	-2
4	Mark	N		Ma rk	3	3
Sheet1

Cell Formulas
Range	Formula
G3:G4	G3	=IF(AND(B3=E3,C3="Y"),F3*-1,F3*1)

Thanks Alan,

I need it to be scalable as I will be adding lots of other names so it will need the option to look up

 

[alansidman]

I don't understand what you are saying. Suggest you show a larger sample and mock up the solution you want for the larger scale. Maybe 8-12 records that represent your actual data.