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 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...Microsoft POS #2
I have a group of customers that I am working on setting up A bundled POS
I have looked at RMS and Microsoft POS. The customer's are small bulk food
stores. They package all of the bulk food in various containers and weigh it
with a Hobart scale producing a label with an system 2 price enbedded
barcode. These are UPC A formats. They are for the most part simple single
store installs and donot require the complex RMS system.
I have setup the Microsoft POS version 2.0 and found it will work perfect
for these customers. The only problem when you programed the system you
l...Rollup 2 and Office 2007
I already have Roll Up 1 and the Office 2007 compatibility patch installed.
If I now install roll up 2 will I have to reinstall the office 2007
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. email@example.com
> I already have Roll Up 1 and the Office 2007 compatibility patch installed.
> If I now install roll up 2 will I have to reinstall the office 2007
...Unable to llaunch FRx
Something on our server hosed FRx between yesterday and today. When users
try to launch FRx Report designer from the Start menu, the FRx splash screen
flashes for a second then disappears. There is no error message and no entry
in the SQL Error logs or the NT event logs.
I can open Report Launcher, but only the FW (Fabricam) and FWC (Fabricam
Canada) reports show up.
This was working fine yesterday. I reran the FRx index scripts but that did
not resolve it.
Anyone have any suggestions?
Maybe the program is corrupted...perhaps a reinstall. But bac...Change File Locations to Private Drive (not Folder)
I know that I can use "File Locations" in "Options" so that whenever I use
the "Open..." command in Word, it will open to a specific folder. I'm
wondering if there is a way that this can be applied not to a folder but to a
specific drive on a network.
Our company has a main public drive and has also assigned each of the Staff
their own private drive. Is there a way to access the "main page" (for lack
of a better term) of my private drive each time I use "Open..." in Word?
Right now it goes to "My Computer" or ...How to get rid of personal folders view in nagivation pane with MA
Hi, trying to help a friend who migrated to hosted mail with MAPI. She is
running Oultlook 2003 with latest updates. In the navigation there are
personal folders and MAPI folders. The personal folders always show at top
and expanded, with the MAPI folders below and not expanded. She only wants
to see the MAPI folders expanded in the navigation view. I tried deleting the
personal folders and it would not let me and it will not let you deliver to
MAPI, which I understand why. Does anyone know how to make this happen?
Is this a hosted Exchange account?
You can change the...[Exchange 2003] Mail enabled public folder and sender address
I have a Windows 2003 domain with a native mode Exchange 2003 organization;
there are some mail enabled public folders.
When a user replies to a message in a public folder, the outgoing mail's
sender address is the user's one; I want it to be the public folder's one,
or at least I'd like the "reply-to" address to be set to the public
How can I accomplish this?
You would need to grant the user permissions to be able to Send As the
public folder. By default, when you reply to a message that is in a PF, the
PF is not composing the ...Outlook 2003
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...Message comes as an attachment
I'm using Exchange 2003 and Outlook. Some clients receive my messages as a
blank email with an attachment that contains the message. For most clients
the messages look fine but there are a few that always do this. I'm
guessing that it is an incompatible setting between our mail servers. Any
idea what I should look for?
A couple things I forgot to mention - the clients are using Exchange 5.5 and
2000, and this apparently only happens when there is an attachment in the
original email. If we send them a message with just text and no attachment
it shows up fine, but if we s...sharing of folders
I tried configuring my folder to share it with the others
but unfortunately as i tour around the outlook i could find
the permissions tab when i right click the properties of a
certain folder. What should I do with this problem? Is
there other way in order I could share my folder? Pls. help
Thanks and regards
You'll have to tell us more about your Outlook version and mail environment.
In the meantime, you might want to take a look at
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Po...Unexpected error message on closing an Excel file
Suddenly I am getting the following message when I try to close a workbook:
"Your formula contains an invalid external reference to a worksheet.
Verify that the path, workbook, and range name or cell reference are
correct, and try again"
The mysterious thing is that it does not happen consistently and that, after
I click OK after the above message, I can still save the file.
What might be the cause of this error message and can the "invalid
reference" be tracked down using one of the utility add-ins such as J.
If it only happens when you close ...how do i add "Software Digrams" Folder in my Visio 2003
how do i add software diags folder in visio 2003 version. Like if i go to
File->New it shows folders like brainstorming, project schedule, block
diagrams but in my case its missing the Software Diags folder which contains
activity diags, web mock ups, use case diags etc. please let me know how to
get that template. thanks.
What edition of Visio are you using? Check by going to the About Microsoft
Office Visio dialog from the Help menu.
"Ankur" <Ankur@discussions.microsoft.com> wrote in message
> how...How do I recover my messages in my mailbox?
When I use Outlook, my e-mails in the original e-mail address are
automatically deleted. But they are still in outlook not in my mail address.
I want them back. Because I can not see my mails when I sign in from other
computers. It sucks.
On Sun, 28 Mar 2010 20:24:01 -0700, whereisnara
Please ask your question in a forum for Outlook; this one is about the
Microsoft Access database product.
Microsoft Access MVP
>When I use Outlook, my e-mails in the original e-mail address are
>automatically deleted. But th...matching contents #2
E1 thru E10 contains sequentially-sorted data. B1 thru B6 contains
sequentially-sorted data which matches SOME (but not ALL) of the data
in Col A. For example.
1 1 1
2 3 2
3 4 3
4 5 4
5 6 5
6 10 6
I need to move the data in the cells in Col B next to the cells in
Col E that have the same contents. For example:
1 1 1
3 3 3
4 4 4
5 5 5
6 6 6
10 10 10
Besides dr...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
...Please ignore #2
Testing a posting problem
...2 register ruinning together on one z report
Is this possible, to have two registers running on one z report ?
We have a small store and would like to setup a second register as a backup,
temporary addition ( during rush hours)
Since we are a small show i do not need to have a separate register reports.
Can two registers ring up all sales together as one ?
How can i set this up ?
No, you can't do that.
You might be able to use the Register Analysis report available in SO
Manager Utilities/Crystal Reports to get something close to a single Z
Tiber Creek Consulting
firstname.lastname@example.org...reason codes #2
I'm having a big problem tracking discounts in RMS. Whenever something is
discounted up front, a reason code is set. There are several I use for
However, when I try to do an Item Movement History report and select based
on those reason codes, I never get any matches. When I do an item history
report for a few weeks, I notice that the only reason codes that are
displayed are the ones pertaining to inventory adjustment. It seems that
reason codes associated with discounts do not display in this report.
HELP! I need these to display to track discounts (and also store use)!
...Installation Error Message
I am attemting to install CRM4 or W2003 server running SQL 2008. I get the
Setup requires SQL Server Reporting Services 2005 Hotfix for role creation
on SQL Reporting Service SP2 Workgroup edition at the specified Reporting
Services Report Server http://XXXXX/reportserver.
It is asking for SQL2005 hotfix yet I am running SQl2008.
...Rendering iframe in an outlook message
what settings (is it security) do I need to make to outlook 2003 to enable
it to render an iframe HTML in a message?
...Server-Requested Client Action MoveCopy, Unable to create dest msg.
Help. This error message displays when my user opens
Outlook 2002. The only fix I can find is to update my
exchange server.. which is already up to date. Any
...Exchange Message Archive/Availability
I have Exchange 5.5 currently. I've posted a few messages this morning on
store limits. Thanks for the replies! This quetion is a geared a bit
Our users receive a lot of email that they want to retain, but business-wise
it does not belong in their mailbox. Meaning, its an email that other people
in the organization should have access to. A quick example of this would be
a customer service rep receiving an email PO. This may be an attachment or
it may be just in the body of the email. Currently, this rep creates a
folder in their mailbox called customer A and retains the email...Recording Macro Error Message
While recording the macro, I access the cell I need the formula in and write
the formula. After writing the formula and hitting ENTER, I receive a
microsoft GUI with "Unable To Record", and ackknowledge the GUI by hitting
OK. The forluma is written to the cell - all even has the desired
When I access the code, the navigation within the worksheet is listed in the
code, but the furmula is not listed.
I tried exiting the file and trying a second time, yet the same results. How
do I "reset" the macro recorder to again begin to record all as...Outlook Express 5 #2
On loading, error message "MSIMN caused an invalid page
fault in module DIRECTDB.dll at 017f:7dbf3070.." Appeared
to coincide with display config change?
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...