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

We've seen your first post. I'm guessing no one has answered because your
question isn't very clear. Please don't multipost.

"RoadKing" wrote:

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