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