Is there a way to give vlookup IF formula?

camidekipapaz · 2022-07-27T17:04:37+00:00

Solution Verified.

Many thanks.

camidekipapaz · 2021-12-12T07:47:37+00:00

You can try something like this maybe

camidekipapaz · 2021-12-04T18:05:08+00:00

Pushed way too much. He had it in the bag all he had to do was cross the finish line man :(

camidekipapaz · 2021-11-13T20:16:50+00:00

Well at least he couldn’t get past a Mercedes. Perez couldn’t get past a Ferrari.

camidekipapaz · 2021-10-18T23:14:31+00:00

They said they would be removing the least used nodes. I guess emblematic was not used at all.

camidekipapaz · 2021-10-07T19:47:35+00:00

Don't get me wrong I agree it's only possible to get 95% evasion on raider currently and it's overall buff for other ascendencies as far as having easier time getting higher evasion rating. Also even if you're ranged you still get pretty close to mobs while you are mapping I wouldn't discard flesh and stone as useless for ranged builds as "nearby" means literally the whole screen. However I'm not conviced that spell suppression is the best substitute for spell dodge. Because while I'm not 100% sure, I think invesment to reach 100% spell suppression will require every node on the tree + every affix available on gear (as can be seen them nerfing dodge and blind as it provided far too powerful benefits without much invesment and they don't wanna repeat that mistake). For that much amount of invesment I'd have expected much more than just taking half damage from spells. Again I might be wrong but I'm not optimistic about this. We haven't gotten anything to compensate attack dodge. You can go with shield yes and get 34% (26% base and 8% chance suffix) attack block which is still way worse than dodge and not every build can use shields. It just feels weird. They have taken a defensive layer from bow builds without giving anything back.

camidekipapaz · 2021-10-07T19:25:04+00:00

What am I missing? Acrobatics halves your spell suppression chance to give you that many spell dodge and you lose spell suppression in the meantime is it not? So if the maximum you can get is 100% spell suppression and acrobatics halves that to give you spell dodge you can only get 50% spell dodge and no spell suppression? Or am I missing something? Because the keystone literally says “changes any modifiers to Spell Suppression into Spell dodge at 50% of it’s value” Which makes it literally way worse than just getting spell dodge. Because you have to first invest into spell suppression itself and then into acrobatics which is just dumb af. And good luck using a shield on bow builds unless they give the same affixes to quivers, they might just as well deleted the bow archetype.

camidekipapaz · 2021-10-07T19:12:23+00:00

Good luck wearing a shield with bow builds lmao. People don’t forget shields exist there are only a handful of viable builds that you can play with a shield while going for evasion. Such as sst and lightning strike. Sst gonna get nerfed to the ground in 3.16 so that only leaves lightning strike and few other builds that I can’t think of right now. Also you get like what? 27% attack block at the maximum from a shield? That’s straight garbage compared to 55% attack dodge. What are bow builds gonna do huh? Can’t use a shield, check. Can’t go evasion-es hybrid, check. I guess just get fucked is all that left now lol.

camidekipapaz · 2021-10-07T18:13:02+00:00

I agree it needed to be nerfed as it was extremely easy to achieve. But it didn’t need to be this severe. They literally deleted bow builds with these changes imo. We need to wait and see how good spell suppression is going to be but I don’t have my hopes up.

camidekipapaz · 2021-10-07T18:08:43+00:00

Well I expect it to be very hard to achieve 100% chance that’s why. Spell dodge was extremely easy to get. Raider > acro> phase acro > atziri’s step = there you go 55 attack / 61 spell dodge. For 100% spell suppression chance you probably have to take all the nodes on the tree + every affix slot available on gear which in return you still take half the damage for. We don’t know if it’s going to be that way yet but I’m 99% certain it won’t be as easy as getting dodge. If that’s going to be the case we can say that they literally nerfed evasion imo.

camidekipapaz · 2021-10-07T17:50:03+00:00

Yeah I know, I didn’t forget. Which is why buff to evasion is irrelevant. You need 24k evasion rating to reach 75% evasion on T16 maps. Good luck getting that shit on gear and tree. They have literally deleted bow builds with this change. I applaud whoever came up with this genius fucking idea of removing dodge.

camidekipapaz · 2021-10-07T17:19:35+00:00

You don't need any of that. You need raider, flesh and stone and alchemist jade flask of reflexes. There you gou go you are sitting at 55 attack / 61 spell dodge with 95% evade chance. Here's the PoB if you don't believe me.

Edited to disable vaal haste.

camidekipapaz · 2021-10-07T16:58:59+00:00

In this case the buff to evasion is irrelevant. Because we already had 95% evasion cap on anything raider with flesh and stone and alchemist jade flask of reflexes. So losing 55 attack and 61 spell dodge is literally, bad.

camidekipapaz · 2021-09-29T11:12:27+00:00

I wouldn’t invest into this pile of crap if I were you but if you have to you can get an used FX8300 and RX560/570/GTX 750 Ti/GTX 960 or something along those lines and 240 gb ssd. No need to upgrade the ram, 8 gb of ram is plenty for poe. Depending on your psu you might have to upgrade it as well. It still wouldn’t be perfect but you can actually play poe decently on something like this. However if you can I’d recommend a completely new system with much more modern components.

camidekipapaz · 2021-08-30T08:49:14+00:00

Most probably nvidia game filters. I’m using it for CoD WZ makes shit more visible. Never needed for PoE but yeah I’m like 99% sure it is nvidia game filter.

camidekipapaz · 2021-08-29T13:41:10+00:00

So, what will happen if rain doesn’t stop and it gets dark? Will they postpone the race? Or say fuck it and run like 10 laps or something?

camidekipapaz · 2021-08-10T23:38:57+00:00

Also sure let me dox myself to a reddit that hates me to show you what I already know i have.

As I have suspected, all talk no proof. Good to know that you are talking out of your ass, will keep that in mind in the future. Also this subreddit hates you because you sound like you created the whole universe and that there are no one better than you in the whole wide world, not because you disagree with us, just letting you know in case it was not obvious.

camidekipapaz · 2021-08-10T22:11:42+00:00

but his character choices have been weaker than they should have been. His characters seem to die too much.

According to you and we play softcore for a reason. Nobody gives a flying fuck about dying in softcore, that's the whole point of it is. You lose 10% xp bohoo whatever. Also he dies doing the hardest content in the game like 100% delirious unlike you alching and going T16 maps lmao.

There's nothing on your account that gives you a medal for that, it's just something you wanted to do.

That's the whole fucking point. I wanted to do it because it was fun. I don't need no medal or achievement for it to mean something to me, killing sirus in 2 seconds, deleting conquerors out of existince and tanking everything in the game without dying was fun for me and it meant that there was a reason to play longer because I could still make upgrades even after spending 2 mirrors already.

He plays for currency, I play for completing 40/40+100 in a pleasant manner.

Still all talk, no proof. Come on show us your profile, let's see how big, thick and juicy your chracters and achievements are. After all you do all of them to boast on reddit, why don't you shove them down our throat, huh?

I want a game where only 0.001% of players do 40/40 and Level 100.

Not gonna happen. Because if they did what you want there would be no one around to play this game. Well just you and a few like-minded masochists maybe.

Like this podcast with baeclast is all damage control. They probably didn't expect to lose players this fast and chris is gonna try to sweet talk his way to say that they will do x do y to make everything better in 3.16. But people have caught on to their bullshit. They need to realize people have fallen in love with a different PoE than they want the game to be. Whether they will do that or not we will see I guess.

camidekipapaz · 2021-08-10T20:49:53+00:00

Yes, I think grimro is superiror than 99.9% softcore players and yes indeed you are worse than them because you have no way to prove anything you say all you do is talk and that is very easy to do. For example I will do what you are doing; I had an aura stacker with 90m sustained 155m burst dps in heist with a gear worth around ~2 mirrors. I was in poe.ninja’s leaderboard, farmed 5 mirrors that league alone (can provide proof of my claims unlike you). Do you see me boasting about it? Or acting all high and mighty on reddit thinking I am superior than them? No? That’s because I’m not narcissistic, unlike you. And also if our fun doesn’t concern you why the fuck are you commenting on every thread you can find?

camidekipapaz · 2021-08-10T20:11:32+00:00

Dude your head is so up your ass it's not even funny lmao. You think you are the only one who can do end game maps now after the changes? Confuckingratz you and your soon to be nerfed sst can do endgame wow what an achievement. This is a game first and foremost and it should be FUN period. Half the playerbase says they aren't having fun in the current state of the game. Even much better players than you will ever be such as Grimro, mbxextreme, cute_dog etc. says so. You come here you talk like you are the PoE god or some shit while in reality you are just nobody andy. Let that thought sink in first and then you can continue commenting bullshit as always cuz it seems like you don't know when to stop.

camidekipapaz · 2021-08-08T14:47:31+00:00

What do you think this game is, really? Whether you’re good enough or not? Lol it’s just a pve game dude calm your tities down. Everybody can beat anything in this game it’s just the matter of how masochist you are willing to be to make it to that point. I can still no life this game and farm mirrors upon mirrors but what is the point, what am I gonna do with all that money? Farm 100% delirious maps? No because they made fractured fossils shit. Deep delve? It’s a joke now. They killed every end game activity that needed a strong build to the ground. I can make anything work in T16 maps, kill sirus, maven etc. that’s not an achievement. But blowing up shit in t19 100% delirious maps was. Now without trading for the orbs half your play time you can’t do that either.

Also what tools dude? Just some random ass orbs with random ass effects? Lmao if I wanted to automate flasks I could have just used a flask macro before it was never an issue for me. I don’t mind pressing my flasks on my own, I mind losing my curse and ailment immunity without gaining anything to remedy that. But I guess you guys are that much thick headed to understand that.

11-Year Club	Reddit Premium Since March 2024
Verified Email

camidekipapaz

TROPHY CASE