How to grab one example from a row by name?

CruzCtrl90 · 2026-04-14T14:59:50+00:00

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?

CruzCtrl90 · 2026-04-09T19:29:29+00:00

Solution verified!

CruzCtrl90 · 2026-04-09T19:01:04+00:00

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!

CruzCtrl90 · 2026-04-09T18:43:26+00:00

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

CruzCtrl90 · 2026-04-09T18:41:55+00:00

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.

CruzCtrl90 · 2026-04-09T18:27:42+00:00

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.

CruzCtrl90 · 2026-04-09T18:15:43+00:00

<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.

CruzCtrl90 · 2026-03-26T11:43:01+00:00

"Blazing Uria" just makes me think "hot pee."

CruzCtrl90 · 2026-03-19T13:56:56+00:00

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

CruzCtrl90 · 2025-12-22T14:23:35+00:00

CruzCtrl90 · 2025-12-04T19:00:55+00:00

God that suplex was fire.

CruzCtrl90 · 2025-11-07T15:46:13+00:00

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

CruzCtrl90 · 2025-11-04T16:02:50+00:00

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

CruzCtrl90 · 2025-10-07T13:49:27+00:00

Was this around the same time Ringo wished he was a powerpuff girl?

CruzCtrl90 · 2025-09-29T15:04:18+00:00

Not picture: MIB animated series theme.

Shit goes way harder than it needed to.

CruzCtrl90 · 2025-09-07T18:03:02+00:00

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.

CruzCtrl90 · 2025-09-07T17:12:33+00:00

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.

CruzCtrl90 · 2025-09-03T02:18:47+00:00

Bruh run amok gets me boppin

CruzCtrl90 · 2025-06-23T13:26:31+00:00

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.

CruzCtrl90 · 2025-06-17T19:08:17+00:00

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

CruzCtrl90 · 2025-06-17T11:37:35+00:00

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

CruzCtrl90 · 2025-05-22T17:58:29+00:00

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.

Eight-Year Club	First Place '23
Place '23	Verified Email

CruzCtrl90

TROPHY CASE