Data Validation List / Sort Problem?

I am using the following formula to sort data from sheet1(data) to be used on sheet3(adjustments) with a data validation list.

Cell A2 is my Property address
=IF(ROW(A1)<=ROWS(OFFSET('Data '!$A$1,1,0,COUNTA('Data '!$A:$A)-1,1)),INDEX(OFFSET('Data '!$A$1,1,0,COUNTA('Data '!$A:$A)-1,1),MOD(SMALL(CODE(LEFT(OFFSET('Data '!$N$1,1,0,COUNTA('Data '!$N:$N)-1,1),1))+(ROW(OFFSET('Data '!$A$1,1,0,COUNTA('Data '!$A:$A)-1,1))-1)/1000,ROW(A1)),1)*1000,),"")

Cell A3 Status of each property, Active, Sold, Closed etc...
=IF(ROW(B1)<=ROWS(OFFSET('Data '!$N$1,1,0,COUNTA('Data '!$N:$N)-1,1)),INDEX(OFFSET('Data '!$N$1,1,0,COUNTA('Data '!$N:$N)-1,1),MOD(SMALL(CODE(LEFT(OFFSET('Data '!$N$1,1,0,COUNTA('Data '!$N:$N)-1,1),1))+(ROW(OFFSET('Data '!$N$1,1,0,COUNTA('Data '!$N:$N)-1,1))-1)/1000,ROW(B1)),1)*1000,),"")

This is working really well thanks to help from this forum, however I ran into a bug while using the spreadhseet. I had a property that had been both sold and active.

When I go to sheet3(adjustments) and used the data validation list to select the property its only allowing the property from one status and the rest of spreadsheet is using data of that property form another status in other words:

When I go to sheet3(adjustments) I should be able to select the status of property I want to use then the next cell allows me to pick amongst those propertys that meet the status criteria and then the rest of the spreadhseet uses the following formula =VLOOKUP($D$2,vlookuptable,30,0)
to input data and make calculations.

The problem in simple english is 12 apple street is in my data twice once as a "sold" status property and once as an "active" status property, both are correct the home was sold a few months ago and is now for sale again("Active")
The problem is I am selecting status "sold" and 12 apple street populates but in the look up formulas it is giving the information for 12 apple street that has an status of "active"

If anyone had any ideas I would really appreciate the feedback .I need 12 apple street to show as both "sold" and "active " status and depending on my selection from my data validation list the look up formula should reference the correct data.

Thanks

p.s i am not entirely comfortable with how the sort formulas are working a bit over my head. I got them from someone on this forum