LinkBack URL
About LinkBacks
I own table with data and I want to return the column "C" values
Used the existing formula in column "D" but the result is not required
Correct and the result found in the column "I"
I own table with data and I want to return the column "C" values
Used the existing formula in column "D" but the result is not required
Correct and the result found in the column "I"
Actually what is your requirement
tell me briefly
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Conditions exist in the "formula" in the column "d"
But this formula do not come correct values found in the column "G"
What is your requirement, what are the conditions the formula looking for?
I want to return the Symbol in the range "G2: G58"
If the conditions existing in the formula achieved
formula Looking for In the column "G" if the date in column "A" exists between the two dates in columns "E", "F"
& If the column "B" equals "Buy", and the column "C" equals "A"
I am not really sure what you want, or how you arrive at the "correct result".
Can you walk me though what you are trying to do (and remember, we have no clue what you are working with, or what you want).
As an alternative, I used this ARRAY formula, copied down...
=INDEX(الرمز,MATCH(E2&F2&B2&C2,$E$2:$E$58&$F$2:$F$58&$B$2:$B$58&$C$2:$C$58,0))
This obviously pulls in all matches, and can be converted to a regular formula using a helper...
=E2&F2&B2&C2
and then change that to this regular formula...
=INDEX(الرمز,MATCH(E2&F2&B2&C2,$Q$2:$Q$58,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you very much, Mr. "FDibbins"
To help, but unfortunately did not work with me, but not required
But this formula has made I want and I want the best formula to check I want
= INDEX ($ G $ 2: $ G $ 58, MATCH (1, IF (A2> = $ E $ 2: $ E $ 58, IF (A2 <= $ F $ 2: $ F $ 58, IF (C2 = "A", IF (B2 = "Buy", 1)))), 0))
That formula you suggest...
=INDEX($G$2:$G$58,MATCH(1,IF(A2>=$E$2:$E$58,IF(A2<=$ F$2:$F$58,IF(C2="A",IF(B2="Buy",1)))),0))
is an ARRAY formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Thank you very much, Mr. "FDibbins"
God bless you
happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks