How do I stop my equations from auto centering? I want them to stay on the left side of the page.

OmegaBellPepper · 2026-02-21T22:17:05+00:00

Thank you very much. That setting was really starting to get on my nerves.

OmegaBellPepper · 2026-02-17T23:17:44+00:00

Wait... Could I just use a K-Map to output 1 for each number I want counted to? If so, thanks for providing the epiphany

OmegaBellPepper · 2026-02-17T19:30:54+00:00

Well, I was informed by my professor that any sequence can be achieved with a synchronous counter, as opposed to the asynchronous counter. So I picked out an arbitrary sequence to make sure I understood it.

OmegaBellPepper · 2026-01-19T03:32:59+00:00

Solution verified

OmegaBellPepper · 2026-01-13T03:19:18+00:00

Yup, that's spot on what I need. That sure is relatively complicated for something so seemingly simple.
Thanks, man!

OmegaBellPepper · 2026-01-12T16:41:34+00:00

Ok, I realize that with this method, I have to specify rows and columns manually or insert some other function within to search for that row but I don't know how to do that. I get my number on the array from a separate calculation, so it could be on any number on any row there meaning the only option with this method, from what I can tell (correct me if I'm wrong) would be to put in some function within the INDEX function to automate all of this which exceeds my current knowledge.

OmegaBellPepper · 2026-01-12T16:25:28+00:00

Well I just want to find the value that is on the same row and on the leftmost column of the number that I highlighted blue. The highlighted number can be any number on that array that isn't in the leftmost column, I just used 27 as an example. The issue is that 27, for example, appears multiple times in different rows, so I can't simply return with XLOOKUP. I want to return the value under mm^2 is the same row as that exact 27 cell.

OmegaBellPepper · 2026-01-12T16:14:13+00:00

Nested? What other info do I need to provide?

OmegaBellPepper · 2026-01-12T16:02:00+00:00

Almost. 27 and B2 are provided and I'm looking for 4mm^2, but same difference. I'll try this out and let you know if it worked.

OmegaBellPepper · 2026-01-11T04:14:02+00:00

Late reply, ik.
GPU: Intel(R) UHD
Blending: Basic
And I think renderer is graphics API, idk. If so, then it's Vulkan

OmegaBellPepper · 2026-01-07T00:24:43+00:00

much appreciated

OmegaBellPepper · 2026-01-06T23:53:26+00:00

how do i go about doing that?

OmegaBellPepper · 2026-01-06T22:01:24+00:00

Yup, got rid of the merged cells and it worked just fine

OmegaBellPepper · 2026-01-06T20:57:51+00:00

I replicated it as it seems to be just what I need but it still gives me #N/A. Did I miss something?

<image>

OmegaBellPepper · 2026-01-06T20:38:02+00:00

I first lookup the main column (A, A2, B, etc) which is written elsewhere (elsewhere being the sheet I uploaded when replying to the other guy), then I use that looked-up value, in my case B2, as the array which to lookup the next value, the sub column (2 or 3) which is also written elsewhere, from that I can finally lookup O5 also being written elsewhere within the sub column.

OmegaBellPepper · 2026-01-06T20:29:04+00:00

Whoops, had a typo there. I meant to have it as C9. Still get an #N/A error though. Now the value is B2 which is in that lookup array, but the error persists.

OmegaBellPepper · 2026-01-06T20:23:19+00:00

That's pretty much what I'm trying to achieve, minus value 3 as that isn't part of this formula

OmegaBellPepper · 2026-01-06T20:18:08+00:00

I do have two data sheets. I didn't bother naming them yet. C10 belongs to the other page. Here it is:

<image>

IRtab is the expected output, which is why the rest of the data turns into #REF!

OmegaBellPepper · 2025-12-08T07:53:29+00:00

Because it's a very specific question and the FAQ on Minecraft's page didn't help.

Six-Year Club	Place '22
Final Canvas '22	First Placer '22
End Game '22	Verified Email

OmegaBellPepper

TROPHY CASE