◆ Excel · formulas

Record Linkage

Match every window and door schedule to plan tags: use lookup formulas to pull size and type from the schedule into th…

2heights
49tasks
10roles do it
See the prompt↓More formulas workflows

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Match every window and door schedule to plan tags: use lookup formulas to pull size and type…+
Match every window and door schedule to plan tags: use lookup formulas to pull size and type from the schedule into the plan tag list, wrap errors with IFERROR and flag blanks or mismatches so procurement orders the correct sizes.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Create a procurement-safe reconciliation between schedule and plan tags — build XLOOKUPs that…+
Create a procurement-safe reconciliation between schedule and plan tags — build XLOOKUPs that return size, frame and count, wrap mismatches in a visible status column with IFERROR, convert any numeric-lookalike text to numbers and produce a short exception report for procurement to avoid wrong orders.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

8 of them
Match every window and door schedule to its tag on the plan so procurement orders the right size.
Match each invoice to the right contract line so I can approve payments without overstating scope.
Match each client's artwork entries to their file number so I can pull the right case notes when writing progress summaries.
Match every sampled transaction back to its source document so I can prove the audit trail.
Match each press inquiry back to the right spokesperson profile so no one is quoted without prep.
Match each open case to the responsible business owner so we can chase overdue investigations.
Match each restoration project’s budget lines back to the correct grant number so funders can be reconciled before the audit.
Match subcontractor invoices back to the purchase orders and contracts so I can approve only what was actually ordered.

Who does this

10 roles
Architectural Project ManagerAuditorCampaign ManagerCompliance ManagerConstruction ManagerDigital Campaign ManagerExecutive AssistantFinance ManagerNetwork AdministratorOffice Manager

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.