2nd request Help with Formula

  • Thread starter Thread starter RoadKing
  • Start date Start date
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)}
 
We've seen your first post. I'm guessing no one has answered because your
question isn't very clear. Please don't multipost.
 
Back
Top