#### Lookup function Question HELP

```This is a multi-part message in MIME format.

------=_NextPart_000_0032_01C4B158.8F36ACE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm trying to perform a lookup function

=3DLOOKUP(H8,sheet2!A:A,sheet2!C:C)

This formula only returns the first item of a list of items matching the
number in A:A  (there could be more than 10 under the catalogue number =
in
A:A.  I've made a list in B:B (1,2,3 etc.) for each of the catalogue =
numbers
in A:A

How would I augment B:B into the formula to coincide with the number in =
the
"B" column?  (Be it 1, 2, 3 etc.)

EX.

A          B          C
2214       1       Red
2214       2       Green
2214       3       Brown

When I enter (2214) into H8 and I want the third item 'BROWN' to show in =
my
cell, what would be the formula?
Also, if there is no "3" then the cell should be left blank.

------=_NextPart_000_0032_01C4B158.8F36ACE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>I'm trying to=20
perform a lookup =
function<BR><BR>=3DLOOKUP(H8,sheet2!A:A,sheet2!C:C)<BR><BR>This=20
formula only returns the first item of a list of items matching =
the<BR>number in=20
A:A&nbsp; (there could be more than 10 under the catalogue number=20
in<BR>A:A.&nbsp; I've made a list in B:B (1,2,3 etc.) for each of the =
catalogue=20
numbers<BR>in A:A<BR><BR>How would I augment B:B into the formula to =
coincide=20
with the number in the<BR>"B" column?&nbsp; (Be it 1, 2, 3=20
etc.)<BR><BR>EX.<BR><BR>A&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; C<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Red<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Green<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 &nbsp;&nbsp;&nbsp;&nbsp;=20
&nbsp;Brown<BR><BR>When I enter (2214) into H8 and I want the third item =
'BROWN'=20
to show in my<BR>cell, what would be the formula?<BR>Also, if there is =
no "3"=20
then the cell should be left blank.<BR><BR>Thank you in=20
<DIV><FONT face=3DArial =
size=3D2>&nbsp;</DIV></FONT></FONT></DIV></BODY></HTML>

------=_NextPart_000_0032_01C4B158.8F36ACE0--

```
 0
jennyrn (8)
10/14/2004 1:12:19 AM
excel 39879 articles. 2 followers.

5 Replies
742 Views

Similar Articles

[PageSpeed] 50

```This is a multi-part message in MIME format.

------=_NextPart_000_002D_01C4B16A.9FEEBED0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Jennifer,

LOOKUP looks up the first record that matches.  It doesn't care about =
multiples.  You can:

1) Filter the table (Data - Filter - Autofilter or Advanced Filter), =
looking for the records you want.  This is a manual operation.=20

2) Have a macro do the above, copying the records wherever you want =
them. =20

To create the table you specify, a macro would have to be written.

It sounds as if you might should oughtta be using Access.  Maybe.

--=20
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
=20
"Jennifer Waterhouse" <jennyrn@telus.net> wrote in message =
news:Tnkbd.60\$_u6.10@edtnps89...
I'm trying to perform a lookup function

=3DLOOKUP(H8,sheet2!A:A,sheet2!C:C)

This formula only returns the first item of a list of items matching =
the
number in A:A  (there could be more than 10 under the catalogue number =
in
A:A.  I've made a list in B:B (1,2,3 etc.) for each of the catalogue =
numbers
in A:A

How would I augment B:B into the formula to coincide with the number =
in the
"B" column?  (Be it 1, 2, 3 etc.)

EX.

A          B          C
2214       1       Red
2214       2       Green
2214       3       Brown

When I enter (2214) into H8 and I want the third item 'BROWN' to show =
in my
cell, what would be the formula?
Also, if there is no "3" then the cell should be left blank.

------=_NextPart_000_002D_01C4B16A.9FEEBED0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Jennifer,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>LOOKUP&nbsp;looks up the first record that =
matches.&nbsp; It=20
doesn't care about multiples.&nbsp; You can:</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>1) Filter the table (Data - Filter - Autofilter or =
Filter), looking for the records you want.&nbsp; This is a manual =
operation.=20
</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>2) Have a macro do the above, copying the records =
wherever you=20
want them.&nbsp; </FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>To create the table you specify, a macro would have =
to be=20
written.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>It sounds as if you might should oughtta be using=20
Access.&nbsp; Maybe.</FONT></DIV>
<DIV><BR>-- <BR>Earl Kiosterud<BR>mvpearl omitthisword at verizon period =

net<BR>-------------------------------------------<BR>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jennifer Waterhouse" &lt;<A=20
href=3D"mailto:jennyrn@telus.net">jennyrn@telus.net</A>&gt; wrote in =
message <A=20
=
href=3D"news:Tnkbd.60\$_u6.10@edtnps89">news:Tnkbd.60\$_u6.10@edtnps89</A>.=
...</DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>I'm trying to=20
perform a lookup =
function<BR><BR>=3DLOOKUP(H8,sheet2!A:A,sheet2!C:C)<BR><BR>This=20
formula only returns the first item of a list of items matching =
the<BR>number=20
in A:A&nbsp; (there could be more than 10 under the catalogue number=20
in<BR>A:A.&nbsp; I've made a list in B:B (1,2,3 etc.) for each of the=20
catalogue numbers<BR>in A:A<BR><BR>How would I augment B:B into the =
formula to=20
coincide with the number in the<BR>"B" column?&nbsp; (Be it 1, 2, 3=20
etc.)<BR><BR>EX.<BR><BR>A&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; C<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Red<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Green<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 &nbsp;&nbsp;&nbsp;&nbsp;=20
&nbsp;Brown<BR><BR>When I enter (2214) into H8 and I want the third =
item=20
'BROWN' to show in my<BR>cell, what would be the formula?<BR>Also, if =
there is=20
no "3" then the cell should be left blank.<BR><BR>Thank you in=20
<DIV><FONT face=3DArial=20
size=3D2>&nbsp;</DIV></FONT></FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_002D_01C4B16A.9FEEBED0--

```
 0
nothanks4548 (968)
10/14/2004 1:21:38 AM
```One way ..

Assuming this table is
in Sheet1, cols A to C
data from row1 down

A          B          C
2214       1       Red
2214       2       Green
2214       3       Brown

In Sheet2
-------------
You have listed the "look-up" criteria in cols A and B
and want to extract the result in col C
(data from row1 down)

A          B          C
2214       3
2214       1
etc

Put in C1:

=IF(ISNA(MATCH(1,(Sheet1!\$A\$1:\$A\$100=A1)*(Sheet1!\$B\$1:\$B\$100=B1),0)),"",INDE
X(Sheet1!\$C\$1:\$C\$100,MATCH(1,(Sheet1!\$A\$1:\$A\$100=A1)*(Sheet1!\$B\$1:\$B\$100=B1)
,0)))

Array-enter the formula, i.e. press CTRL+SHIFT+ENTER

Copy C1 down

For the sample data: C1, C2 will return Brown, Red
Unmatched cases will return blanks ""

--
Rgds
Max
xl 97
---
xdemechanik <at>yahoo<dot>com
----
"Jennifer Waterhouse" <jennyrn@telus.net> wrote in message
news:Tnkbd.60\$_u6.10@edtnps89...
I'm trying to perform a lookup function

=LOOKUP(H8,sheet2!A:A,sheet2!C:C)

This formula only returns the first item of a list of items matching the
number in A:A  (there could be more than 10 under the catalogue number in
A:A.  I've made a list in B:B (1,2,3 etc.) for each of the catalogue numbers
in A:A

How would I augment B:B into the formula to coincide with the number in the
"B" column?  (Be it 1, 2, 3 etc.)

EX.

When I enter (2214) into H8 and I want the third item 'BROWN' to show in my
cell, what would be the formula?
Also, if there is no "3" then the cell should be left blank.

```
 0
demechanik (4694)
10/14/2004 1:31:43 AM
```So you have 2214 in H8.
Where do you have the 3?  I'm gonna use G8.

Then try this:

=INDEX(Sheet2!C1:C999,MATCH(1,((Sheet2!A1:A999=H8)*(Sheet2!B1:B999=G8)),0))

This is an array formula.  Hit ctrl-shift-enter instead of enter.  If you do it
correctly, excel will wrap curly brackets {} around your formula.  (don't type
them yourself.)

But it'll return #n/a if there isn't a match.

So you could either hide the with conditional formatting--white font on white
fill (but the error is still there).

Or you could use something like:

=if(iserror(longformulahere),"",longformulahere)

Or just check the portion which causes the error:
=IF(ISERROR(MATCH(1,((Sheet2!A1:A999=H8)*(Sheet2!B1:B999=G8)),0)),"",
INDEX(Sheet2!C1:C999,MATCH(1,((Sheet2!A1:A999=H8)*(Sheet2!B1:B999=G8)),0)))

(all one cell--and still ctrl-shift-entered.)

> Jennifer Waterhouse wrote:
>
> I'm trying to perform a lookup function
>
> =LOOKUP(H8,sheet2!A:A,sheet2!C:C)
>
> This formula only returns the first item of a list of items matching the
> number in A:A  (there could be more than 10 under the catalogue number in
> A:A.  I've made a list in B:B (1,2,3 etc.) for each of the catalogue numbers
> in A:A
>
> How would I augment B:B into the formula to coincide with the number in the
> "B" column?  (Be it 1, 2, 3 etc.)
>
> EX.
>
> A          B          C
> 2214       1       Red
> 2214       2       Green
> 2214       3       Brown
>
> When I enter (2214) into H8 and I want the third item 'BROWN' to show in my
> cell, what would be the formula?
> Also, if there is no "3" then the cell should be left blank.
>
>

--

Dave Peterson
ec35720@msn.com
```
 0
ec35720 (10082)
10/14/2004 2:51:32 AM
```ps.  If you really want to post to lots of groups.  Send one message to all the
groups at the same time (include them in the header).

That way, all the responses will go to each group, too.

But it's not usually necessary.  This one fit nicely in the .worksheet.functions
newsgroup--even though you got multiple responses here.

> Jennifer Waterhouse wrote:
>
> I'm trying to perform a lookup function
>
> =LOOKUP(H8,sheet2!A:A,sheet2!C:C)
>
> This formula only returns the first item of a list of items matching the
> number in A:A  (there could be more than 10 under the catalogue number in
> A:A.  I've made a list in B:B (1,2,3 etc.) for each of the catalogue numbers
> in A:A
>
> How would I augment B:B into the formula to coincide with the number in the
> "B" column?  (Be it 1, 2, 3 etc.)
>
> EX.
>
> A          B          C
> 2214       1       Red
> 2214       2       Green
> 2214       3       Brown
>
> When I enter (2214) into H8 and I want the third item 'BROWN' to show in my
> cell, what would be the formula?
> Also, if there is no "3" then the cell should be left blank.
>
>

--

Dave Peterson
ec35720@msn.com
```
 0
ec35720 (10082)
10/14/2004 3:08:25 AM
```This is a multi-part message in MIME format.

------=_NextPart_000_005C_01C4B549.962406C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Jennifer
I would try to make new column merging column A and B. That way i would =
have a unique no. E.g when u join column A and B u will get 22141. So =
when u will enter 22143 it will get u the brown. There is function =
available in excel to join two columns

thanks
"Jennifer Waterhouse" <jennyrn@telus.net> wrote in message =
news:Tnkbd.60\$_u6.10@edtnps89...
I'm trying to perform a lookup function

=3DLOOKUP(H8,sheet2!A:A,sheet2!C:C)

This formula only returns the first item of a list of items matching =
the
number in A:A  (there could be more than 10 under the catalogue number =
in
A:A.  I've made a list in B:B (1,2,3 etc.) for each of the catalogue =
numbers
in A:A

How would I augment B:B into the formula to coincide with the number =
in the
"B" column?  (Be it 1, 2, 3 etc.)

EX.

A          B          C
2214       1       Red
2214       2       Green
2214       3       Brown

When I enter (2214) into H8 and I want the third item 'BROWN' to show =
in my
cell, what would be the formula?
Also, if there is no "3" then the cell should be left blank.

------=_NextPart_000_005C_01C4B549.962406C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Dear Jennifer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I would try to make new column merging =
column A and=20
B. That way i would have a unique no. E.g when u join column A and B u =
will get=20
22141. So when u will enter 22143 it will get u the&nbsp;brown. There is =

function available in excel to join two columns</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>thanks</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jennifer Waterhouse" &lt;<A=20
href=3D"mailto:jennyrn@telus.net">jennyrn@telus.net</A>&gt; wrote in =
message <A=20
=
href=3D"news:Tnkbd.60\$_u6.10@edtnps89">news:Tnkbd.60\$_u6.10@edtnps89</A>.=
...</DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2><FONT face=3D"Times New Roman" =
size=3D3>I'm trying to=20
perform a lookup =
function<BR><BR>=3DLOOKUP(H8,sheet2!A:A,sheet2!C:C)<BR><BR>This=20
formula only returns the first item of a list of items matching =
the<BR>number=20
in A:A&nbsp; (there could be more than 10 under the catalogue number=20
in<BR>A:A.&nbsp; I've made a list in B:B (1,2,3 etc.) for each of the=20
catalogue numbers<BR>in A:A<BR><BR>How would I augment B:B into the =
formula to=20
coincide with the number in the<BR>"B" column?&nbsp; (Be it 1, 2, 3=20
etc.)<BR><BR>EX.<BR><BR>A&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; C<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Red<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
Green<BR>2214=20
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 &nbsp;&nbsp;&nbsp;&nbsp;=20
&nbsp;Brown<BR><BR>When I enter (2214) into H8 and I want the third =
item=20
'BROWN' to show in my<BR>cell, what would be the formula?<BR>Also, if =
there is=20
no "3" then the cell should be left blank.<BR><BR>Thank you in=20
<DIV><FONT face=3DArial=20
size=3D2>&nbsp;</DIV></FONT></FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_005C_01C4B549.962406C0--

```
 0
10/19/2004 2:35:06 AM

Similar Artilces:

Restricting the reactivationg cases function
In many customer service environments, the reactivation of existing cases is an exceptional procedure, to be performed only by a supervisor. I can't seem to find the right way of assigning a security role to accomplish this. Any ideas? -- Juan Fidalgo Sr. Bus. Analyst SCI If the role has update case, read activity and write activity then you should be able to Reactivate the case. Please also refer to Appendix A: Security Roles and Privileges http://msdn2.microsoft.com/en-us/library/bb954998.aspx This doc has detial privileges that are required in each of SDK message. -- This p...

Hey Microsoft! Exchange 2003 Question
Can an Exchange administrator modify the Level1 and Level2 attachment lists? I don't want my Outlook users to have to save a certain type of file to the disk first. If so how? Thanks This may help: http://www.slipstick.com/outlook/esecup/admin.htm -- Mark Fugatt Exchange MVP http://www.exchangetrainer.com http://www.msexchange.org "Jeff" <anonymous@discussions.microsoft.com> wrote in message news:0be901c3db86\$5e56e700\$a501280a@phx.gbl... > Can an Exchange administrator modify the Level1 and > Level2 attachment lists? > I don't want my Outlook users to ha...

Excel Functions #2
hi guys, just wondered if anyone knew which function i would use to do this, because im fairly novice with excel: Basically if the cell value is above 110 i want the cell to turn green if the cell value is between 110 and 105 i want it to turn yellow if the cell value is below 105 i want it to turn red any help would be seriously appreciated. thanks spotseven wrote: > hi guys, just wondered if anyone knew which function i would use to > do this, because im fairly novice with excel: > > Basically if the cell value is above 110 i want the cell to turn gr...

TRIM FUNCTION in QUERY
Hello, What do I put to trim off the spaces after a value in query? The table is obtained from ODBC link and the values on a field somehow got spaces. Example: My field in the query is: WC: PO_WORKCENTER_ID Not sure WC: TRIM(PO_WORKCENTER_ID) ???? That should work. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Cam" wrote: > Hello, > > What do I put to trim off the spaces after a value in query? The table is > obtained from ODBC link and the values on a field somehow got spaces. Example: > > My...

Button/Macro Not Working, Help!
I have a macro that pulls up Report Manager and prints out pre-define views. The macro works fine only after I use Report Manager the firs time. If I exit my workbook and Excel, then return to it, th button/macro does not function. Nothing happens until I manully us Report Manager again. Is there a bug with this or am I missin something -- Message posted from http://www.ExcelForum.com Post your code. Gord Dibben Excel MVP On Thu, 20 May 2004 08:38:55 -0500, baston <<baston.16k4at@excelforum-nospam.com>> wrote: >I have a macro that pulls up Report Manager and prints out pre...

Off topic: VB6 question
sorry this is way off topic. using _vb6_: i'm trying to add/replace nodes to an xml document via CreateTextNode: xml = "<item>floogle</item>" set newNode = oDom.createTextNode(xml) call dDom.replaceChild( newNode, bloogleNode) It works ok. But I can no longer find the new node in the document via an xpath query. When I save the doc to disk I can see the new node but its been escaped, presumably because it was a text node: <root> <item>wayheyhepahole</item>&lt;item&gt;floogle&lt;/item&gt; </root> I guess my question is: H...

Create form similar to MS Access 2000 Help
Is it possible to create a form that works similar to the Help - Index form in Access 2000? My StreetTable consists of the following fields: Street_ID(autonumber), StreetName(text), Directions(memo). I want to be able to type the beginning letters of the street and the List of StreetNames continually reduces until I see the street I need in the StreetNames window. I would then click on that street and the Directions would appear in the third window panel. Since I'm dealing with approx. 5000 streets, scrolling really isn't an option that I want to consider. I found that a combo ...

HELP: Excel userform version control issue
Hi All, I have an excel userform that is posted on my companys intranet. The issue I am having is, users are saving this form to their hard drive and then using it(Instead of launching it everytime from intranet), SO basically when I have a new version of form on intranet they still use the old version as they have a habbit of saving it on their hard drive. Is there a way to resove this? something like they would see a popup message saying that "This is an older version that you are using, Please launch the form from Intranet for newer version". Thanks in advan...

Outlook attachment problems
Dear Our oversea office sender using Outlook Sending message (HTML) insert a picture sending message to my office, when I have received the attachment auto duplicate one set in the message. I have asked the sender try remove the picture and FORWARD to my e-mail, but the attachment sill in the message and auto duplicate one set attachment. Out overseas office using MS SBS , user setup WG mode for outlook download message. I am not sure which part problems or virus effect. Please advice how to solve out the problems ASAP. JACKIE ...

Help with
I am currently in the process of migrating exchange 2000 to exchange 2003 on new hardware. I have transfered the RUS role, offline address book role and replicated the public folders ect. and now am beginning to move maiboxes. I noticed 3 very repetive errors in the application event log however. I was wondering if someone could tell me whether these messages are somthing I should be concerned with. See them below. So far I have no user complaints about outlook. Thanks. Event ID: 9320 Source MSExchangeSA Type Warning Description OALGen could not generate full details for some en...

Help with Inbox repair tool please
I have a problem with my outlook 2000 and have been advised to use the inbox repair tool. I have opened the inbox repair tool, and I am asked to enter the folder name or to browse and enter the location of the folder, I need to enter the delete items folder but do not know where to find it. Any help appreciated. John The Inbox Repair Tool works against Personal Folders Files (.PST files), not against individual folders within the .PST file. If you don't know where your .PST file is located, you can find it this way: In Outlook, make sure the Folder List is visible (View | Folder...

Counting Question #3
I have three columns: dates, values, and names 10/17 \$300 Jim 10/17 \$300 Jim 10/17 \$200 Tom 10/17 \$100 Jim When I enter Jim and \$300 in to two separate cells, in a third cell I want to count the number of "days" it applies to (all the way down the spreadsheet.) So in other words, there are two instances in the same day of Jim and \$300, but since it all happened on one day, the answer would be one. Hope I explained it well. =sumproduct(--(b1:b10=x1),--(c1:c10=x2)) where x1 holds the amount, x2 holds the name and B1:B10 holds the list of amounts and c1:c10 holds the list of...

Help; how do i change the waiting circle (in IE tab) to anything e
I am making a website and i have a lot of wait time for my server-side pages to do their work. The waiting circle icon gives me a headache so I would like to change that to something else please. I remember IE6 had a great Microsoft Flag logo that would wave while a page would load. Could I get IE8 to use this logo? Sorry Trozza, you can't. "Trozza Mited" <Trozza Mited@discussions.microsoft.com> wrote in message news:9C401644-2391-4317-92BD-D7F3DFD2B06C@microsoft.com... > I am making a website and i have a lot of wait time for my server-side > p...

Backup service authentication question
Hello, I have a fairly small Exchange 2003 installation. My HQ site has a single Exchange 2k3 BE server. The HQ site is connected to 3 other remote sites via a mesh network. Each of those sites has a local Exchange 2k3 BE server. I use BackupExec 11d for my backups. I recently noticed that if my Exchange server in the HQ site is unavailable, the Exchange backups in the remote sites fail in connecting to the resource. It appears like an authentication issue. When the main site comes back on line, backups can run again without issue. Each site has at least one 2k3 domain controlle...

Lookup Wizard changing Data Type
I am trying to make Lookups from Table Field to Table Field and generally it seems OK. However the LookupWizard is changing the Data Type from Text to Number (I guess it's looking at the ID?) Data picked from Combo Box 'looks' OK in Table view A Query view is asking for a number but displays the Text field value when a valid ID number is added. Viewing Results in FrontPage Database Wizard, and using hand coded .asp querie, it's showing the ID field value. I can see why... Any ideas? Merci. Yes, the wizard isn't the problem it's the use of Lookup Fields in ...

Help With Problem: Nested IF Function, Office2K v Office2003
Hello Group, I'm looking for some help with a nested IF worksheet function. Shown below is a formula that I'm using in a model. =SUM(IF(worksheet!\$A\$3:\$A\$54=DATEVALUE("9/1/2005"),IF(worksheet!\$B\$3:\$B\$54="<90",worksheet!\$C\$3:\$C\$54,0),0)) If short, what I'm trying to do is scan the data in two columns and for any cells which meet the TRUE case in both columns, then sum the third numbers for all cases returning TRUE-TRUE. If either cell returns a FALSE, then enter 0. I created the original formulas and model in Office2000 and have used the model for more tha...

Are there functions/Or Events that are called automatically when the database file first opens and When it closes?
All, I'm assuming its "Public Function init_something()" but I can't seem to find a reference to the correct syntax. I'm using Access 2007. Basically what I'm trying to do is initialize a list of global variables and I can't seem to figure out how to do it. Option Compare Database Public VariableName As String 'Call Init - Will throw an error 'VariableName = "Hello World" - Will throw an error Option Explicit Public Function Init() VariableName = "Hello World" End Function Private Sub btName_Click() ...

Newbie to New Database Query - Can you change a spreadsheet to a table if so how? I have a lot of spreadsheets that I would like to work with in New Database Query. Can this be done. Any help will be greatly appreciated. In general, if you select a range and give it a name....MS Query will recognize it as a data source: Example for data in Cells A1:Z500, with column headings (EmpID, FName, Lname, etc): Select A1:Z500 In the Names box (just above the Col_A heading) type rngMyData1 Press [Enter] Next, save your workbook. Then...Data>Import External Data>New Database Query When y...

MS Query help required
Hi I have a spreadsheet on my notebook which I use for DBA services at a particular client. It connects to database server via an existing ODBC database connection extracting data from system tables. I would like to be able use this spreadsheet at other clients, WITHOUT having to create a new ODBC connection. Is there any way that this can be accomplished? The ideal scenario would be that the logon credentials and server address reside on one sheet and upon arrival at another client, one merely changes this information and then queries the database. Any help would be appreciated. Regards -...

opencurrentdatabase error/help
dears, im opening an access03 database with vb6 like application.opencurrentdatabase("c:/documents and settings/admin/folder/database.mdb",true,"password") application.docmd.open"myform" application.docmd.maximise docmd.maximise included in form open event also in the database kindly help me with (1) after this code runs access opening with small rectangular window(half of screen vertically) even all access databases are opening this way (2) if the above said path changes for the database error 7866 occuring in error event i would like to include some c...

Need help with a formula 01-23-10
I am looking for a formula that will compute an average of a number of non contiguous cells such as G8, G16, G24, G36, etc. Each of these cells has a formula which computes an average of a range of cells. With the helpm of this forum, I have been able to find a formula which does that AND uses values only when they are greater than zero and does not display #DIV/0!. But I cannot fin a fromula that will do the next step- Take an average of those specific cells AND use only the ones where the cell is >0, Example G8=100, G16=85, G24 is blank, G36=75, then this formula would ca...