Lookup based on criteria in 2 columns
I am trying to use a vlookup or other function to return the value in the
amount column based on the location and date. Here is a sample of my data:
Location Date Amount
101 9/15/8 10
101 9/16/8 20
101 9/17/8 15
102 9/15/8 50
102 9/16/8 75
102 9/17/8 67
For example if I wanted to return the amount for location 102 on 9/15/8,
what formula would I use? I tried using variations of vlookups but had no
Peo Sjo...Outlook needs Outlook Express to work
I've installed my Outlook 2002 on my new Vista PC (I had Xp before). Now when
I start Outlook it says "requires Outlook Express 4.01 or greater". I've been
looking for Outlook Express to download and install but no joy. No CD came
with my new Vista PC. Any ideas, short of buying a more modern Outlook?
Vista doesn't actually support Outlook 2002 or older. Outlook Express is
part of Internet Explorer but with the advent of Vista, it was switched to
Windows Mail. There is no more Outlook Express.
You could attempt however to create a profile using workgroup or c...Counting number of X's in a column
I need to sum up the number of "Xs" in a column. I would be extremely
grateful if someone could help me with the formula. I cannot seem to get one
to work. We are using Excel 2003.
Environmental Education Association of Washington
(remove nothere from the email address if mailing direct)
"Susie Harris" <SusieHarris@discussions.microsoft.com> wrote in message
> I need to sum up the number of "Xs" in a col..."The connection to the Exchange server is unavailable. Outlook must be online or connected to complete this action"
I have setup a number of user accounts and the relative mailboxes without
However, since this afternoon, if I try and connect to a newly mailbox
through the email accounts wizard I get the following error message: "The
connection to the Exchange server is unavailable. Outlook must be online or
connected to complete this action".
This also occurs when I go to File>Open>Other User's Folder... and I try and
lookup an existing account/mailbox that I know I have permission to.
I know Outlook is connected to the Exchange server (I can ping, send and
receive emails) ...Outlook 2003 keeps crashing #2
I get this message when I look in System information. Outlook keeps
crashing quite often. I cannot for example delete two messages without
outlook crashing. My colleagues do not have this problem. We are using
the Microsoft mail exhange server.
Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0,
faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0,
fault address 0x003b6e16.
Does anyone has a solution?=20
1) I would definitely apply Service Pack 2for Office 2003 + applicable
critical security updates.
2) Have you tried starting O...Sort ascending, make changes, restore previous order
I've got an AutoFilter in a spreadsheet. I want to sort ascending, mak
some changes to some cells, then restore the previous order. Can thi
be done easily or will this require some programming??
Thanks in advane!
BVHis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=859
View this thread: http://www.excelforum.com/showthread.php?threadid=47508
I'd use a helper column.
Put =row() and drag down.
Convert it to values (edit|copy, edit|paste special|values)
Do all y...Outlook 2003 and "Check Names"
We are testing Outlook 2003 at our office now and there is
one very frustrating "feature" that is bugging all of us.
When we create a new e-mail message and type in the first
name of a person from the global address book and hit ctrl-
k to check the name...we get a response that Outlook
doesn't recognize the name and there are "no suggestions".
The only way Check Name will successfully resolve the name
is if we type it last name first (ie, Gates, Bill). This
was not the case in Office XP or Outlook 2000. You could
search by first name (or partial first name)...Transferring over outlook data to new XP machine
How do I transfer over my old emails, address book to my
new XP machine? I have looked over the internet and found
nothing the tells me EXACTLY how to do this, any help
would be greatly appreciated.
If your using MS Outlook copy your .PST file across and import it into the new install.
>If your using MS Outlook copy your .PST file across and import it into the
No, don't import it. Simply use "File">"Open"
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the nam...Crash on 'Send"
My wife's Intel Celeron running ME started having this problem
sporadically - now constantly.
Outlook 2000 receives OK - everything seems fine until you hit the 'Send'
button then Outlook crashes giving an error message that says 'Outlook has
caused an error in <unknown> and has to shut down. If the problem persists
you may have to restart your computer.'
Re-starting however has no effect.
I have re-installed Office. Used 'Detect & Repair' under the 'Help' tab, and
installed all patches/updates from the Office site. But this error
continues, now...make subreport2 visible based on condition
Help, I am running Access 2003 and have
trouble getting this work right.
I have an unbound subreport that contains 3
additional subreports. I want only one of the 3
to be visible based on the value in a combo
box on a selection form. I can't seem to get
the reference right and have tried several
If Forms!frmWeeklyGLrpt!cboCC = 1 Then
Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDA.Visible = True
Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDB.Visible = False
Me!subrptGLWeekly.Report!subrptGLWeeklyCMRDC.Visible = False
If Forms!frmWeeklyGL...Reminders in Outlook
Since upgrading to Great Plains 9.0, several users are not getting their
appointment reminders in Outlook 2003. They all show up at once after
rebooting computer. Outlook settings are set appropriately. Any ideas?
...Outlook default to paragraph
To whom ever can help,
> When using Microsoft Outlook, and starting a new E-
Mail, The default
> format is to "paragraph" which double spaces. Is there
> select under a New Message, Format, Style, "Normal" as
> Thank you in advance
>To whom ever can help,
>> When using Microsoft Outlook, and starting a new E-
>Mail, The default
>> format is to "paragraph" which double spaces. Is there
>> select unde...cant start outlook pst file to large
Hi I hope somebody may be able to help im new to outlook and now I cant start
outlook message says cannot open your default email folders pst file its too
large as I cannot open outlook I cannot delete old folders
See if this helps: http://support.microsoft.com/kb/296088
Ben M. Schorr, MVP
Roland Schorr & Tower
Author: The Lawyer's Guide to Microsoft Outlook 2007:
"Ray" <Ray@discussions.microsoft.com> wrote in message
we have one client pc with Outlook 2003 where the following problem
if a mail is replied from a user created sub folder of the inbox, the
reply will not appear in sent mails, but will end up in the same sub
folder, sender and recipient appear as identical. The mail goes out
properly though, it's just that Outlook sets internally sender =
recipient and bounces the reply back to the subfolder in which the
original mail is stored.
This happens on a Win 2000 machine with SP4 and all updates, the other
clients use Outlook 2000 or XP and there is no such problem.
There are no ru...Outlook "Ruler" won't go away
I don't know how I turned this on so I don't know how to
turn it off. It splits my emails so that I can only type
so far over before it kicks me back to the left margin
and makes me start a new line. Can anyone help me?
...outlook 98 corperate forms
In a corperate environment, Outlook 98 forms not active
for using on some of the PCs. Why it happens? How can I
solve this problem.
...Moving Contacts to Outlook Address Book
Need some help. How do I move the names and email
addresses from my Contacts list to my Outlook Address
Book. When I click on the Outlook Address Book it is
empty, but when I click on the Contacts List all the
names are there. I am using Outlook 2002. Any help
would be appreciated, Thanks Bob
What is the problem?
The OAB should be empty. Entries reside in the Contacts Folder.
"Bob R" <firstname.lastname@example.org> wrote in message
> Need some help. How do I ...DVD off Center and Right side cut off in WMP 11
I am using Windows XP Pro SP3 and just updated to WMP 11. When I play a DVD
it seems to be zoomed in or stretched on the screen and the right side of the
movie is cut off. I've tried everything I know to do to fix it, and that
knowledge is slim! Any suggestions are very much appreciated!
The Out of Office Reply will not be sent outside the
network. I have exchange 5.5 and have read the faqs but
the only fix I found did not work. Here is the number
for the fix that I found: Q176161.
Thank you for your time and help,
1. Make sure your Exchange server's Internet Mail Service is configured to
allow Automatic Replies to the Internet; that's the most common reason it
2. Reconsider if you really want to use it. You're going to automatically
reply to every message you receive; including spam. That's a good way to
confirm to the spammer...OutLook and Notes co-existing.
Outlook and Notes co-existing.
Is is possible to mantain Notes as the primary MAPI mail server, but to have
Outlook on the same machine, with a separate mail account.
I wish to use the automation features of office with the outlook
application, to build a solution, but the clients mail is LN. I only wish to
use the system to send mails.
Does LN support any objects for sending, To, Subject, Body, Attachment, etc
which I could use from Access. ?
Any reference material, articles etc would help also.
Phone: 01 6104509
Fax:01 601 ...Import from Eudora 6 to Outlook 2003
I am trying to import messages from Eudora 6 to Outlook 2003. I am receiving the error message "The mail folder could not be opened. If another application is using this file, please close and try again.
No other applications are running
Thanks for any help
see article 257354 of the microsoft knowledge base on
"Outlook Cannot Import Eudora Messages When Eudora Mail Is
Stored in a Non-Default Location"
>I am trying to import messages from Eudora 6 to Outlook
2003. I am receiving the error message ...Mails not appearing in Inbox although on Server and viewable by colleague
I have searched the archives and found a few more or less related
topics to my problem, but unfortunately none of them helped.
Here's my problem:
I know that I recieve several mails at a specific time each day. Those
mails are sent to a colleague of mine and myself but only he recieves
My admins looked on the Exchange Server and all say, that they can
definetely see these emails in the server logs and that the server
delivered them to the right mailbox.
If my colleague looks into my mailbox before(!!) I open Outlook, he
sees these mails as unread in my inbox. As soon as I op...Outlook freezes after sending one email after upgrading 4.0
We just upgraded from 3.0 to 4.0 this weekend. All client machines have had
the desktop client upgraded and 2 have the same issue. One is XP with Outlook
2003 and the other is Vista with Outlook 2007. Open opens and the CRM addin
initializes correctly. As soon as you compose and send an email, Outlook
locks up and you have to kill the process in task manager to close Outlook.
I've had the same problem and have tried all I can think of...how did you fix
> We just upgraded from 3.0 to 4.0 this weekend. All client machines have...Can I make messages unable to be forwarded by the receiver?
We are interested in setting up a private email group at work that receives
Is there a way to make the emails that these users will receive unable to be
forwarded to people outside of the group? Make private, or somehow else
prevent the information from getting outside of the approved recipient list?
no. and you can't keep people from printing it, copying and pasting the
contents of it, taking a screen shot of it, etc, etc...
"Jonna Kosalko" wrote:
> We are interested in setting up a private email group at work that receives
...Office 2003, Outlook (Outlook Today)...
OK, this is driving me nuts.
I note that w' 2003 (and XP (2002)?) the default install sets the
startup folder to the Inbox.
IIRC, one of the earlier Offices installed Outlook to startup w' that
"all in one view" - Outlook Today.
So just as a wee test - I thought I'd try that for a while, and indeed I
found it quite handy to be able to see all pertinent data on the one
*However* (and I'm wondering if this is the case with others), I *HAVE*
to use my mouse, whenever I switch to the Inbox, or Calendar, or Tasks
to get the damn focus onto a 'sujbect&...