PC Review


Reply
Thread Tools Rate Thread

2nd request Help with Formula

 
 
RoadKing
Guest
Posts: n/a
 
      26th Aug 2007
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)}


 
Reply With Quote
 
 
 
 
=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=
Guest
Posts: n/a
 
      27th Aug 2007
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)}
>
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Request dernspiker Microsoft Excel Worksheet Functions 4 13th Mar 2009 06:34 PM
formula request.... Shevvie Microsoft Excel Misc 1 18th Dec 2007 03:48 PM
Formula request ~~~AAA~~~ Microsoft Excel Discussion 2 14th Sep 2006 08:51 AM
Request a formula! IcoHolic Microsoft Excel Worksheet Functions 0 21st Aug 2006 05:23 PM
If you drag a meeting request or task request from your Inbox toCalendar or Tasks, the request is automatically accepted and an acceptancereply is sent to the senders. 34345445 Microsoft Access 0 3rd Mar 2006 01:09 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:07 PM.