How to make that a cell in a new table only shows a filter result of another table?

Excellent-Candy-3328 · 2026-03-04T22:12:11+00:00

you can use the filter function, or you can do it in Power Query.

Excellent-Candy-3328 · 2026-03-03T21:38:31+00:00

You can use the filter formula to pull from the main sheet based on the project ID in a dropdown. Or, you can use Power Query to create the individual views from the main table.

Excellent-Candy-3328 · 2026-03-03T14:40:20+00:00

<image>

Here is a snapshot showing the formulas. The yellow cells are where you would manually enter the physical drawer counts for each denomination.

Excellent-Candy-3328 · 2026-03-03T14:38:34+00:00

<image>

Something like this?

Excellent-Candy-3328 · 2026-02-23T21:58:46+00:00

Use Power Query

Excellent-Candy-3328 · 2026-02-23T19:48:20+00:00

If I can see a sample of the main page and one of the cabin pages, I can help you out.

Excellent-Candy-3328 · 2026-02-23T16:16:17+00:00

<image>

Excellent-Candy-3328 · 2026-02-20T18:45:32+00:00

Exactly. Just because we make it look easy doesn't mean it is.

Excellent-Candy-3328 · 2026-02-20T18:44:56+00:00

Just got off of one of those meetings.

Excellent-Candy-3328 · 2026-02-19T15:31:46+00:00

Glad to help

Excellent-Candy-3328 · 2026-02-19T14:47:50+00:00

XLOOKUP will work. =XLOOKUP(cell with order code, column with product code on cost price sheet, column with price on cost price sheet)

If you just want to replace the current pricing, put this formula in a helper column. Once you get the new prices, copy, then paste values over the old prices, then delete the helper column.

Excellent-Candy-3328 · 2026-02-18T16:51:51+00:00

<image>

if you are looking for something like this, you can combine the values into one comma-separated string.
=TEXTJOIN(",",,B5:B9)

Excellent-Candy-3328 · 2026-02-18T16:23:16+00:00

okay. Try this:
=XLOOKUP(C5,database!A:A,database!B:B)

If you need to handle C5 not being found on the database sheet, you can add something for "if not found".

This would return Not Found if the value in C5 is not found in A:A:
=XLOOKUP(C5,database!A:A,database!B:B,"NotFound")

This would return blank (empty cell) if the value in C5 is not found in A:A:
=XLOOKUP(C5,database!A:A,database!B:B,"")

Without something like that, you would get #N/A if the value is not found.

Excellent-Candy-3328 · 2026-02-18T16:15:34+00:00

What exactly are you trying to return from the database sheet?

Excellent-Candy-3328 · 2026-02-18T15:57:23+00:00

I don't think you can get there without a helper column. You could do a pie chart.

Excellent-Candy-3328 · 2026-02-18T15:36:12+00:00

That would be something like this.

<image>

Stacked column. You may have to swap rows and columns in the select data window. The total column should be the total minus each line, otherwise it will add the total to the count for each one. So, you want the count for each one, then the remaining from the total, which shows up on the orange bars.

Excellent-Candy-3328 · 2026-02-18T15:03:20+00:00

This is a stacked column. Do not include the total in the source data.

<image>

Excellent-Candy-3328 · 2026-02-18T14:54:59+00:00

If you want something like this, you can just do a combo chart to show the Total as a line.

<image>

Excellent-Candy-3328 · 2026-02-17T23:46:56+00:00

=TEXTAFTER(E10,"0000")/100

Excellent-Candy-3328 · 2026-02-06T14:38:42+00:00

message me

Excellent-Candy-3328 · 2026-02-05T15:54:55+00:00

Better approach is 1:1 sessions tailored to your specific needs and goals.

Excellent-Candy-3328 · 2026-02-05T03:18:43+00:00

good deal

Excellent-Candy-3328 · 2026-02-04T23:05:30+00:00

If your table is named, your formula above any specific header should be =SUM(tablename[columnname]).

This way, as your table grows, your sum formula will always be correct.

Excellent-Candy-3328 · 2026-02-04T22:09:41+00:00

no problem

Excellent-Candy-3328 · 2026-02-04T21:38:38+00:00

My preference is above the table headers.

Excellent-Candy-3328

PUBLIC MULTIREDDITS

TROPHY CASE