Match Property ID to Listing Price
I have a list of sold properties by ID and need to retrieve their original listing price from a master database.
=VLOOKUP(A2,E:H,3,FALSE) How it works: This VLOOKUP formula takes the 'Sold Property ID' from column A, searches for an exact match in the first column of your 'Master Database' (E:H), and once found, returns the value from the third column of that master database range, which is the 'Listing Price'. The 'FALSE' argument ensures that only exact matches are returned, preventing incorrect price assignments.
Data Setup
| Sold Property ID | Sold Date | Sold Price | Original Listing Price | Master Property ID | Address | Listing Price (Master) | Status | ||
|---|---|---|---|---|---|---|---|---|---|
| 1001 | 2023-01-15 | $550 | 000 | 1001 | 123 Main St | $575 | 000 | Sold | |
| 1003 | 2023-02-20 | $720 | 000 | 1002 | 456 Oak Ave | $620 | 000 | Sold | |
| 1005 | 2023-03-10 | $480 | 000 | 1003 | 789 Pine Ln | $750 | 000 | Sold | |
| 1002 | 2023-04-05 | $610 | 000 | 1004 | 101 Elm Rd | $900 | 000 | Active | |
| 1006 | 2023-05-12 | $890 | 000 | 1005 | 202 Birch Ct | $500 | 000 | Sold | |
| 1006 | 303 Cedar Blvd | $920 | 000 | Sold |
Step-by-Step Guide
Identify the 'Sold Property ID' in your current list (e.g., cell A2) as your lookup value.
Define the 'Master Database' range (e.g., E:H) where the first column contains the 'Master Property ID' and a subsequent column contains the 'Listing Price'.
Determine the column index number for 'Listing Price' within your defined 'Master Database' range (e.g., if 'Master Property ID' is column 1, 'Address' is column 2, then 'Listing Price' is column 3).
Set the 'range_lookup' argument to FALSE to ensure an exact match for the Property ID.
Enter the formula in the first cell where you want the listing price to appear (e.g., D2) and drag it down to apply to all sold properties.
Explore More
Count Listings in Specific Zip Code
I want to count how many active property listings I have in the 90210 zip code area.
Total Sales Volume by Agent Name
I need to calculate the total value of all properties sold by a specific agent named 'Sarah' this quarter.
Compile Property Features List
I have columns for 'Pool', 'Garage', and 'Garden' marked with 'Yes' and want to join the feature names into a description.
Calculate Monthly Payment for Client Budget
I need to show a client what their monthly payment would be for a $350,000 house at current rates.