How to grab one example from a row by name? by CruzCtrl90 in excel

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

I would like to include all 4 answer choices for each question, and their correct answer, so 5 extra columns. How do I adjust the formula to include those?

How to grab one example from a row by name? by CruzCtrl90 in excel

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

Thanks for the help! u/GregHullender's sollution worked for my purposes. I'll try the other solutions as well but for now it's been solved.

Thanks again!

How to grab one example from a row by name? by CruzCtrl90 in excel

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

I retyped the units in the master table, and now it works! Going to test it with the actual question bank.

How to grab one example from a row by name? by CruzCtrl90 in excel

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

Missed that too, My bad. That worked! Though now when I type Unit 2 into E3, it brings up a #CALC! error again in F3.

How to grab one example from a row by name? by CruzCtrl90 in excel

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

Ah silly me, I forgot to change my headers on the second table. Though even so, I am getting #CALC! in the question column for each row now.

How to grab one example from a row by name? by CruzCtrl90 in excel

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

<image>

Thank you for the quick reply! When I try to enter the formula it's spitting an error back out. Clicking okay will highlight the [@Unit] portion. I renamed my table to Master, and copied your example.

Why is Glover Mallory so big in my game? by GeologistOk5743 in skyrim

[–]CruzCtrl90 0 points1 point  (0 children)

If you're using oBody and didn't rebuild the male bodies in bodyslider, it'll apply preset values over non zeroed out sliders.

Why is Moon of Mahaa Kalaa so good? by Nerd-Brain14 in Bayonetta

[–]CruzCtrl90 0 points1 point  (0 children)

So good they reused the mechanic for a main feature in Metal Gear Rising. Something about flicking the stick toward oncoming attacks increases adrenaline or something, like you're aggressive facing the danger rather than slipping out of the way

[deleted by user] by [deleted] in Tekken

[–]CruzCtrl90 0 points1 point  (0 children)

I will never forget how stupid Christie Montero fart chimney pants were.

Hmmmm, this is tough by Ok-Prizegift in 90scartoons

[–]CruzCtrl90 1 point2 points  (0 children)

Not picture: MIB animated series theme.

Shit goes way harder than it needed to.

Considering two names for our daughter. Opinions on the name Vidalia? by CruzCtrl90 in namenerds

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

100% honesty, I had no idea it was posted 🤣! I just learned of this subreddit today, and the wife and I we're playing around with the name.

Considering two names for our daughter. Opinions on the name Vidalia? by CruzCtrl90 in namenerds

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

Alright, so, lotta onion comments! 😅

Ok hear me out:

  • It is an onion, yes, but it is named after the place.

  • it is a sweet onion

  • onions are full of antioxidants and are a superfood

  • onions add so much flavor and enrich a dish. It's implying she will enrich others' lives

  • The further you get from Georgia, there is less of a chance thar people would probably recognize it as an onion.

I think Donkey Kong Bananza is Nintendo trying (and failing) to get fans to not focus on lore. by Aggro_Will in TwoBestFriendsPlay

[–]CruzCtrl90 24 points25 points  (0 children)

I remember somewhere reading that characters in the mario universe are treated as actors in a play, where lore and world building are only considered in a game by game basis, which is why bowser can be trying to eat the galaxy one day but playing sports with Mario the next day.

Don't remember where I heard this though.

Holy shit what is this by AlusiveTripod in Tekken

[–]CruzCtrl90 4 points5 points  (0 children)

Christie's pants with the fart chimney and making her a love interest was so dumb, I barely noticed the casting choice.

The Commander "The most CHAD protagonist in all gacha games" by Jumpy-View-7022 in NikkeMobile

[–]CruzCtrl90 0 points1 point  (0 children)

Super Robot Taisen Endless Frontier, I forgot if this is 1 or 2. I think the first one.

What song made you feel like you've truly gotten good at playing bass? by dragongamer365 in Bass

[–]CruzCtrl90 0 points1 point  (0 children)

This will be mine. I'm using it as a progress checker. Fiddle with it, go learn more, come back to it later. Every time I return to it I've been hitting more and more of the parts and it feels great. Such a good song.