Returning Data from a third cell in same row that meets two other

[Guest]

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.

 

[Frank Kabel]

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

 

[Guest]

One way

=INDEX(E2:E100,MATCH(1,(A2:A100=36751)*(B2:B100="Total Returns"),0))

entered with ctrl + shift & enter

you can replace your 2 conditions with cell references where you would pur
rhe conditions, that way you don't have to edit the formula every time you
change conditons


Regards

Peo Sjoblom

 

[Guest]

thanks for your help. for some reason i still can't get this to work. i've
been playing around with it all day. it seems to get hung up on the second
part when it looks up "total returns" it wants to locate some other info in
one of the other cells and returns a "false" for that part of the formula.
any other ideas would be appreachiated.

thanks