Forum Discussion
Solved
If two cells contain specific values, portray data in third cell
Hoping y'all can help me write a formula because I'm pretty new to excel. What I've done is created a web query to track live costs for magic the gathering cards, so I can catalog my collection and s...
=INDEX(Table4_2[Market Price]:Table4_2[Market Price],MATCH(1,(Table4_2[SET]:Table4_2[SET]='TEST FORMULA OWNED CARDS'!J2)*(Table4_2[PRODUCT]:Table4_2[PRODUCT]='TEST FORMULA OWNED CARDS'!M2),0))Does this formula return the expected result of 0,13? I assume that within the "test formula owned cards" sheet we have to reference single cells like this:
'TEST FORMULA OWNED CARDS'!J2.
Otherwise you can send me your file without sensitive data and i'll try to help.
=INDEX(Table4_2[Market Price]:Table4_2[Market Price],MATCH(1,(Table4_2[SET]:Table4_2[SET]='TEST FORMULA OWNED CARDS'!J2)*(Table4_2[PRODUCT]:Table4_2[PRODUCT]='TEST FORMULA OWNED CARDS'!M2),0))Does this formula return the expected result of 0,13? I assume that within the "test formula owned cards" sheet we have to reference single cells like this:
'TEST FORMULA OWNED CARDS'!J2.
Otherwise you can send me your file without sensitive data and i'll try to help.
YES! Thank you so much! I had the idea to build this data sheet a week or so ago, having never even opened excel before. My original test of 1 set worked perfectly, but this large scale issue has held me up for days. I really appreciate this ❤️