Yes, there are a couple of ways. I'd suggest you loook at array formulas
(first) and D-functions (second). Here are some articles from my site to
get you started:

http://www.grbps.com/Excel5.pdf (array formulae)

http://www.grbps.com/Excel3.pdf (D-functions)

I'd start with arrays since D-functions require your sheet to be set up
in a certain way before they'll work.