How to Build a Unit Finder Tab in Google Sheets So Your Team Can Match Renters to Listings
TL;DR
- A renter texts asking for a 2-bed under a certain budget.
- Instead of scrolling the whole listing sheet, type the request into a small Finder tab and let FILTER and SORT return the units that fit.
- Here is the step-by-step setup.
On this page
- How to Build a Unit Finder Tab in Google Sheets So Your Team Can Match Renters to Listings
- The listing tab this works with
- Step 1: Set up the Finder inputs
- Step 2: Return the matching units with FILTER
- Step 3: Make the neighborhood optional
- Step 4: Sort by rent and handle "no match"
- Step 5: Use named ranges so the formula stays readable
- Step 6: Add an inventory snapshot with COUNTIFS
- Step 7: Give each teammate a filter view
- A short routine that keeps matches honest
- Where Sarah AI fits
- FAQ

How to Build a Unit Finder Tab in Google Sheets So Your Team Can Match Renters to Listings
A text comes in: "Do you have a 2 bed under $1,900 for December?" If your listings live in a Google Sheet, someone now has to scroll it, mentally skip the rented rows, compare rents and check dates. With 8 units that's fine. With 40 spread across a few neighborhoods, it's how the wrong unit gets quoted, or how a good fit gets missed entirely.
The fix is a small second tab, call it Finder, where you type the renter's request into a few cells and the sheet returns only the units that fit, sorted by rent. It uses built-in Google Sheets functions, no add-ons, and it reads from the listing sheet you already have. Each function below links to its page in Google's Docs Editors Help.
This guide assumes your listings already follow a one-row-per-unit structure. If they don't yet, start with our rental listing Google Sheet setup guide, then come back.
The listing tab this works with
The formulas below assume a tab named Listings with headers in row 1 and these columns:
| Column | Field | Example |
|---|---|---|
| A | Unit ID | KED-2B-2F |
| B | Address and unit | 1234 N Kedzie, 2F |
| C | Neighborhood | Logan Square |
| D | Bedrooms | 2 |
| E | Bathrooms | 1 |
| F | Rent | 1850 |
| G | Available date | 2026-12-01 |
| H | Status | Available |
| I | Showing notes | Occupied, 24h notice |
| J | Last updated | 2026-11-16 |
Two things matter for matching. Bedrooms and rent must be plain numbers ("2", not "2BR"; "1850", not "$1,850/mo"), and Available date must be a real date, not text. If a formula returns nothing when you know a unit fits, a number stored as text is the usual cause.
Step 1: Set up the Finder inputs
Add a new tab named Finder and label four input cells:
| Cell | Label | What you type |
|---|---|---|
| B1 | Bedrooms | 2 |
| B2 | Max rent | 1900 |
| B3 | Move in by | 2026-12-01 |
| B4 | Neighborhood (optional) | Logan Square, or leave blank |
Make B4 a dropdown so nobody types "Logan Sq" one day and "logan square" the next. Google Sheets lets you create an in-cell dropdown list with Data > Data validation > Add rule, and you can choose Dropdown from a range and point it at a short list of the neighborhoods you actually have. You can do the same for B1 with the bedroom counts you list (0 for studios, 1, 2, 3).
Step 2: Return the matching units with FILTER
The FILTER function returns only the rows of a range that meet every condition you give it. In Finder!A7, enter:
=FILTER(Listings!A2:J,
Listings!H2:H="Available",
Listings!D2:D=B1,
Listings!F2:F<=B2,
Listings!G2:G<=B3)
Read it line by line: from the Listings data, keep rows where the status is Available, the bedroom count equals what's in B1, the rent is at or below B2, and the unit is available on or before the move-in date in B3. Every condition range has to be the same height as the data range, which is why they all start at row 2 and run to the bottom of the column.
Put headers in row 6 (Unit ID, Address, Neighborhood, and so on) so the results are easy to read.
Step 3: Make the neighborhood optional
Sometimes the renter names an area, sometimes they don't. Add one more condition that passes every row when B4 is blank and only matching rows when it isn't:
(B4="")+(Listings!C2:C=B4)>0
Add it as a fifth condition inside the FILTER, after the date line. Adding the two tests together works like "either one is true," so a blank B4 lets everything through.
Step 4: Sort by rent and handle "no match"
Two small upgrades make the results more useful.
First, wrap the formula in the SORT function so the lowest rent shows first. SORT takes the range, the column number to sort by, and TRUE for ascending. Rent is the 6th column of A:J, so the sort column is 6.
Second, Google's FILTER page notes that when no rows meet the conditions, FILTER returns #N/A. An error cell looks broken to a teammate. The IFNA function swaps that error for a message you choose.
The full formula:
=IFNA(
SORT(
FILTER(Listings!A2:J,
Listings!H2:H="Available",
Listings!D2:D=B1,
Listings!F2:F<=B2,
Listings!G2:G<=B3,
(B4="")+(Listings!C2:C=B4)>0),
6, TRUE),
"No match. Try one more bedroom option, a higher budget or a later date.")
When there's no match, that message is a prompt for the next question to the renter, not a dead end. Our post on offering a renter another unit by text covers how to have that conversation.
Step 5: Use named ranges so the formula stays readable
Listings!F2:F doesn't tell a new teammate much. Google Sheets lets you name a range of cells from Data > Named ranges, so the column can be called rent instead. Names can contain only letters, numbers and underscores, with no spaces, so use names like unit_status, bedrooms, rent and available_date.
After naming, the core of the formula reads almost like a sentence:
FILTER(Listings!A2:J, unit_status="Available", bedrooms=B1, rent<=B2, available_date<=B3)
One caution from Google's help page: if you delete a named range, formulas that reference it stop working. Rename instead of deleting when you reorganize.
Step 6: Add an inventory snapshot with COUNTIFS
Above or beside the Finder inputs, a small count table answers "what do we have right now?" at a glance. COUNTIFS counts rows that meet several criteria at once:
=COUNTIFS(Listings!H2:H, "Available", Listings!D2:D, 2)
That counts available 2-bedroom units. Make one row each for studios, 1, 2 and 3 bedrooms. When a renter asks for a 3 bed and the count shows 0, you know before you even run the Finder, and you can plan the reply around the 2 beds you do have.
Step 7: Give each teammate a filter view
The Finder tab works for one request at a time. If two people use it at once, they overwrite each other's inputs. For a small brokerage, two habits help:
- Make a copy of the Finder tab per person (Finder - Ana, Finder - Marcus). Each copy reads from the same Listings tab, so everyone sees the same inventory.
- Use filter views on the Listings tab itself. Google Sheets' sort and filter help page explains that a regular filter changes what everyone with access sees, while a filter view applies only to your view and can be saved and named. Save views like "Available 2 beds" or "Available by Dec 1" so anyone can browse without disturbing the shared layout.
A short routine that keeps matches honest
The Finder is only as accurate as the Listings tab it reads. Fold three checks into the weekly sheet review you already do:
- Run the Finder with a broad search (every bedroom count you list, a high budget, a date far out) and confirm every unit it returns is truly open.
- Look for units that never appear. A blank rent or a bedroom count typed as text will silently drop a unit from every match.
- Spot-check the date column. A unit marked Available with last month's date may have rented without anyone updating the status.
If your showings run through Google Calendar, our Google Calendar showing setup guide covers the other half of the workflow, so the match turns into a booked time.
Where Sarah AI fits
The Finder tab is a useful tool for people. It's also the same idea behind Sarah AI by NextGen Fusion AI: an SMS assistant for Chicago real estate agents, small brokerages, property managers and landlords that replies to property-inquiry texts 24/7. Sarah asks your qualifying questions, matches listings from your Google Sheet by bedroom count, offers an open time from your Google Calendar and confirms it by text, then handles reminders and reschedules. You can take over any thread from the dashboard. Setup is free and the first month is $1. Learn more on the Sarah AI page or see how it works for property managers.
Either way, a clean sheet with numbers stored as numbers is what makes a good match possible.
Book a demo of Sarah AI and bring your listing sheet. We'll walk through how it would read your units.
FAQ
Why does my FILTER formula return #N/A? FILTER returns #N/A when no rows meet all the conditions. Wrap it in IFNA to show a plain message instead, then check whether the request is too narrow or whether bedrooms and rent are stored as text instead of numbers.
Can I match on more than bedrooms and rent? Yes. Each extra condition is one more line inside FILTER, as long as the condition range is the same height as the data range. Available date and neighborhood are the most useful additions for most rental lists.
Will the Finder tab change my Listings tab? No. FILTER only reads from Listings and displays results on the Finder tab. Editing the Finder inputs never changes a listing row.
How do several people use the Finder at the same time? Give each person their own copy of the Finder tab, all reading from the same Listings tab, or use saved filter views on the Listings tab, which apply only to the person using them.
Do I need Google Workspace for this? No. FILTER, SORT, IFNA, COUNTIFS, named ranges and filter views are all standard Google Sheets features documented in Google's Docs Editors Help.
Related
Text Sarah now.
Free 2-week supervised pilot.
(844) 681-7964Sarah is AI. Reply STOP anytime.
