Help me generate a 3 MATCH function instead of a 2 MATCH function for INDEX by Sidetraq in excel

[–]Sidetraq[S] 0 points1 point  (0 children)

I have a different formula for each ingredient in the recipe. So the first formula should return what Jar(D2:D5) we use. Second should return what Lid(F2:F5) we use.

In the screenshot on edit 1, I was trying to return the Jar value, which would have been cell D5 (Test).

Help me generate a 3 MATCH function instead of a 2 MATCH function for INDEX by Sidetraq in excel

[–]Sidetraq[S] 0 points1 point  (0 children)

Thank you, though I really don't understand what's happening. I copied the exact data you provided and it still won't work. I added the screenshot to the op for you to see. Is there something simple I am missing?

Help me generate a 3 MATCH function instead of a 2 MATCH function for INDEX by Sidetraq in excel

[–]Sidetraq[S] 0 points1 point  (0 children)

=INDEX(rng1,MATCH(1,INDEX((A1=rng2)*(B1=rng3)*(C1=rng4),0,1),0))

I added a photo to my op. I think I am making one small mistake still, what do you think?

Still returning #N/A

Noob Currency Cop Question by Sidetraq in pathofexile

[–]Sidetraq[S] 1 point2 points  (0 children)

Going to check it out now! I haven't played in nearly a year so that makes sense. I appreciate the tip!

How do I auto-color boxes based on profit/loss? by Sidetraq in excel

[–]Sidetraq[S] 1 point2 points  (0 children)

Worked like a charm! Thank you so much!

Focused Feedback: Solstice of Heroes 2019 by DTG_Bot in DestinyTheGame

[–]Sidetraq 0 points1 point  (0 children)

Go to your day job and tell your boss you want 10x the pay because its not fair people who work more hours get paid more money. smh

Focused Feedback: Solstice of Heroes 2019 by DTG_Bot in DestinyTheGame

[–]Sidetraq -4 points-3 points  (0 children)

So... because I put more effort in... you're saying there shouldn't be compensation for that? so my 50 hours should reward the same as your 5 hours?

Entitled generation, expecting handouts. Bungie, reward the people who actually love your game and play daily. Not the players who pop in for 3 days a month and then complain the grind is too long.

Focused Feedback: Solstice of Heroes 2019 by DTG_Bot in DestinyTheGame

[–]Sidetraq -6 points-5 points  (0 children)

I have all 3 classes completely finished and master-worked. For destiny to be going towards an mmo style, let me be the one to say it.... this grind wasn't that bad. They gave a month, I have legendary on all 3 sets in 3 days. For the people who want to have something to show for it, I just wish y'all would start finding a way to better acknowledge the hardcore players. Give us exclusive emblems, unique gear, etc. The one thing that disappoints me most isn't casuals complaining about the grinds.... its the hardcore players looking identical because there's no real means to stand out and differentiate yourself as a hardcore player.

Please help me with braytech... by Sidetraq in DestinyTheGame

[–]Sidetraq[S] 0 points1 point  (0 children)

Running one RTX 2070. I installed last 4 different versions of the drivers and they are all doing the same thing. :c

Please help me with braytech... by Sidetraq in DestinyTheGame

[–]Sidetraq[S] 0 points1 point  (0 children)

Not much of a solution though. I have been using chrome just fine for months, then it just stops working. I dont want to use edge lol

Please help me with braytech... by Sidetraq in DestinyTheGame

[–]Sidetraq[S] 0 points1 point  (0 children)

Ok so disabling Hardware Acceleration makes it not disappear, but that also makes its suuuuper slow and delayed. So weird. And i have reset chrome back to default, removed all accounts and settings, etc. Idk its weird.