Returning Data from a third cell in same row that meets two other
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. |
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. |
One way
=INDEX(E2:E100,MATCH(1,(A2:A100=36751)*(B2:B100="T otal 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 "USChad" wrote: 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. |
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 "Peo Sjoblom" wrote: One way =INDEX(E2:E100,MATCH(1,(A2:A100=36751)*(B2:B100="T otal 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 "USChad" wrote: 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. |
All times are GMT +1. The time now is 04:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com