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.

I sent an earlier posting, with an attachment,

Thanks

John

[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)}