2nd request Help with Formula

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

Barb Reinhardt

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top