hengishammer
New Member
- Joined
- Feb 7, 2019
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I have an index match formula that I'm not even sure that is possible to do.
This is what I wrote:
=(IF(V14>0,INDEX(CONTR_REF!J:J,MATCH(C14&H14,CONTR_REF!A:A,IF(W14>0,INDEX(CONTR_REF!K:K,MATCH(C14&H14,CONTR_REF!A:A,IF(W14&V14=BLANK,""))))))))
I want to index match a certain column if column V is greater than 0, and column W has nothing.
I want to index match a DIFFERENT column if column W is greater than 0, and column V has nothing.
I want nothing to happen if both Column V and W are populated
I want nothing to happen if both Columns V and W aren't populated.
Is it possible to write a single formula to display properly in column R?
I tried nested IFs but I think I researched myself into a margarita....
This is what I wrote:
=(IF(V14>0,INDEX(CONTR_REF!J:J,MATCH(C14&H14,CONTR_REF!A:A,IF(W14>0,INDEX(CONTR_REF!K:K,MATCH(C14&H14,CONTR_REF!A:A,IF(W14&V14=BLANK,""))))))))
I want to index match a certain column if column V is greater than 0, and column W has nothing.
I want to index match a DIFFERENT column if column W is greater than 0, and column V has nothing.
I want nothing to happen if both Column V and W are populated
I want nothing to happen if both Columns V and W aren't populated.
Is it possible to write a single formula to display properly in column R?
I tried nested IFs but I think I researched myself into a margarita....