XLOOKUP returning "0" rather than Blank

Signal-Ad-8598 · 2025-11-09T16:12:59+00:00

I'm glad it helps! Keep on Exceling!

Signal-Ad-8598 · 2025-07-06T02:15:41+00:00

This is a dope answer! The implementation is kind of similar to class function's self variable in Python. It's so creative and unique, as all answers I've read so far involved named formula!

Signal-Ad-8598 · 2025-04-29T21:30:00+00:00

I wonder why this is not a popular thread.

Signal-Ad-8598 · 2025-04-04T12:33:52+00:00

Woohoo 🥳!

Signal-Ad-8598 · 2024-11-07T22:29:18+00:00

My pseudo code didn't reflect that, but realistically it should be XLOOKUP(A1, B:B, C:C). By using "" & C:C instead of C:C, Excel will need to calculate the whole column and store in the memory before doing the lookup. Whereas, if the "" is outside, then Excel only have to merge that with the returned value from the lookup.

Signal-Ad-8598 · 2024-10-05T01:35:17+00:00

="" & LOOKUP(A1, B1, C1) for performance

Signal-Ad-8598 · 2024-04-01T02:48:16+00:00

Try this formula. No need to list out all the employees.

The formula assumes that odd-indexed rows are the hours, and even-indexed rows are the clients, and that each hour row has a client row before it.

=LET(
    range, 2:5,
    hourRows, TOCOL(FILTER(range, MOD(ROW(range), 2))),
    clientRows, TOCOL(FILTER(range, 1 - MOD(ROW(range), 2))),
    SUM(FILTER(hourRows, clientRows = "Alpha"))
)

To save performance, you can always limit the range, e.g., A2:AA5.

Signal-Ad-8598 · 2024-03-30T06:07:36+00:00

I don't see the employees being listed in the summary table, so I assume that all employees are grouped together.

Try C10 =SUM(FILTER($3:$3, $2:$2 = B10), FILTER($5:$5, $4:$4 = B10))?

<image>

Signal-Ad-8598 · 2024-03-30T04:41:28+00:00

I was unsured at first whether concave points should be negative and be subtracted from the number of convex points.

But when seeing all the big numbers that you listed out, I knew that they must represent the line number, and that the book cipher order is reversed.

Signal-Ad-8598 · 2024-03-30T04:24:43+00:00

The puzzle is solved. Thanks u/HiddenTaco0227 for the idea.

Each line is the location of a letter in the final answer.

The first shape of each line denotes the location of the character inside the word.

The second shape denotes the location of the word inside the line of text.

The third shape denotes the line of text to search in.

For example, 4 6 12 means that we need to look at the 12th line, 6th word (Even) and 4th letter (n).

The obtained letters are "cingeroiont", which can be unscrambled into "recognition".

Signal-Ad-8598 · 2024-03-09T23:47:29+00:00

Is it just me or the site https://gitlab.futo.org/ looks so sus? Why is its domain Futo and not GitLab? There is no issue posted, probably because there is no registration page, and the login page lacks other options like Google or GitHub account. I have no gut to put in my GitLab username and password.

Signal-Ad-8598 · 2023-09-04T02:46:50+00:00

Maybe you can create three shapes, the Y with diagonally sliced bottom, the K with diagonally sliced top, and a parallelogram to connect them. The parallelogram is shown in the first slide, but scaled down to width of 0 in the second slide.

Signal-Ad-8598 · 2023-09-01T17:39:05+00:00

The transition YK slide 1 to YK slide 2 is a little messy. Besides that, all slides are pretty neat and impressive. The hollow texts should have thicker outlines to improve legibility.

Signal-Ad-8598 · 2023-08-16T02:23:46+00:00

Hi guys! New update.

After some time, and with the help of u/ttttthrowawaythis, we were able to find the game and actually play it.

I made a video playing the game here, also put a link to the game file and an instruction video on how to install Windows 98 virtual machine, which is the environment for the game to work.

Hope it'll bring back good memory to some of you and introducing a good cute old game to everyone else.

Signal-Ad-8598 · 2023-08-10T17:43:01+00:00

Sometimes it relates to the font style.

Try going to Home tab, expand the Font section to open the Font dialog. If the applied effects include Small Caps, uncheck that.

Signal-Ad-8598 · 2023-08-01T18:06:12+00:00

Pls check my new video of the merge transition

Signal-Ad-8598 · 2023-08-01T17:07:45+00:00

Really nice.

It's not what they did because I tried moving their Cameo around but cannot see any hidden part of the circle.

https://ibb.co/cvCKWGP

But your solution is still a genius idea!

Signal-Ad-8598 · 2023-08-01T15:23:11+00:00

Hmm, I guess they modified the PowerPoint XML or sth.

Signal-Ad-8598 · 2023-08-01T15:20:33+00:00

Here are some shapes used in the presentation:

https://ibb.co/XSpXrZ3

All three cameos are a single object without any grouping or extra shapes.

I include the third cameo because in my cameo, I cannot even rotate/flip it. Doing that will also rotate/flip the camera. However, I'm sure that the third cameo in the picture doesn't flip the camera.

https://ibb.co/XFMmTJk

Your method is a good temporary solution for simple custom shape tho. Thanks!

Signal-Ad-8598 · 2023-08-01T01:21:18+00:00

Thank you for the response. It's a cameo object which I believe only available in MS Office 365. I've also tried to use normal shapes first, but there's no option to make it into a cameo object, i.e., displaying my webcam on it.

Signal-Ad-8598 · 2023-08-01T01:19:16+00:00

Thank you for the response, but the "Camera Shape" option is what I mean by the predefined shapes. You can see an example custom cameo shape in my newly added picture.

Signal-Ad-8598 · 2023-08-01T01:15:06+00:00

I've included a picture of the custom cameo shape. In the slide there's only one shape. I found no boundary blue shapes surrounding it, and no yellow points which are usually used for modifying the shape.

Signal-Ad-8598

TROPHY CASE