Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
entering data in certain cell | Links and Linking in Excel | |||
I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) | |||
I need a macro to find cut and paste data to new cell | Excel Discussion (Misc queries) | |||
Dragging cell data | Excel Discussion (Misc queries) |