Formula updated

[RoadKing]

A B
C D



Name or Address
1110 NW 69 Terr



Address
Owner



1110 NW 69 Terr
Abbott, Claudia & Rubino, Peggy

2




[Address] =IF($D3=400,"",INDEX('Legal (2)'!$A1:$A400,$D3,1))



[Owner] =IF($D3=400,"",INDEX('Legal (2)'!$B$1:$B$400,$D3,1))



[Col-D]

{=IF(LEN(TRIM('Data Sheet'!$D$20))>0,SMALL(IF('Legal (2)'!$A$1:$A$400='Data
Sheet'!$D$20,ROW($B1:$B400),400),ROW('Data Sheet'!A1)),400)}



Good afternoon:

This formula works when an address is entered. I need the option to enter
an address or a name and have it populate the same.



Thanks

John





Worksheet Legal(2)

Address
Owner

1110 NW 69 Terr
Abbott, Claudia & Rubino, Peggy

6970 NW 17 Ct
Agudelo, Byron & Julia

1685 NW 69 Terr
Alcana, Rosalind

6955 NW 12 St
Ali, Asmat [Jim] & Kamla

6915 NW 16 St
Allaire, Paul & Garafola, Barbara

6970 Margate Blvd
Altman, Frances