I am trying to use a single condition with a slope formula. I have used this in the past for the STDEV.S formula and got it to work, but am having trouble building one for the SLOPE formula. I only need it to incorporate one condition (a match between fund symbols... ACTABT eg).

This is what I have used in the past for the STDEV.S, is there a way to tweak this and use it for SLOPE?
IFERROR(STDEV.S(IF($B2=Sheet2!$B$5:$B$13479,Sheet2 !$E$5:$E$13479)),"NO DATA")

I have a list of symbols in column "B" (uniquie) and want to say if the symbol in say B2=Sheet1!B:B then give me the slope. Any help is much appreciated!

Cheers