searchlisted

# Search Tracker Look up a company or URL across **both sheets** of `List.xlsx` (Sheet1 = active applications, Rejected = rejected/closed applications). ## What to do based on input ### User gives a URL 1. Open `List.xlsx` with openpyxl (use temp copy if PermissionError). 2. Search column C in **both sheets** for that URL (exact or substring match). Also handle cells with `=HYPERLINK(...)` formula — extract the URL from inside the formula. 3. If found → show all matching rows (see Output Format below). 4. If not found → use `requests` to fetch the page and extract the `<title>` tag. Parse the company name from the title (format is usually `"Job Title - Company | Platform"`). Then search column A in both sheets by that company name. 5. Report clearly: "Not in tracker" if nothing matches after both attempts. ### User gives a company name only 1. Open `List.xlsx` with openpyxl (use temp copy if PermissionError). 2. Search column A in **both sheets** — case-insensitive substring match. 3. Show all matching rows across both sheets (see Output Format below). 4. Report "Not in tracker" if nothing found. ## Output Format Group results by sheet, show row number, company, role, status (with emoji), URL, and any comments: ``` Found 3 match(es) for "Theodo": [Sheet1] Row 45 — Theodo | AI Engineer | ✅ Applied URL: https://welcometothejungle.com/... Row 67 — Theodo | Tech Lead | 🕐 In Progress URL: https://... [Rejected] Row 12 — Theodo |