Hi
try the following array formula (entered with cTRL+SHIFT+ENTER):
=INDEX(E1:E55000,MATCH(1,(A1:A55000=36571)*(B1:550 00="Total Returns"),0))

--
Regards
Frank Kabel
Frankfurt, Germany
"USChad" schrieb im Newsbeitrag
...
I'm looking for a formula that will return a result from a cell on a same
row
as two other cells that meet certain criteria. I'm sure there is a way to
do
this but i am a novice at this kind of stuff and can't seem to figure it
out.

For example i want a cell to = what is in column E when column A="36751"
and
when column B="Total Returns" The spreadsheet has 55000 rows. there will
only be one instance where both these criteria are met. i want to use
this
to create a seperate spreadsheet with just info i need and can update on a
daily basis.

thanks in advance for helping me out.