Lookup function help please

I'm trying to use the following LookUp function but it keeps on coming up as 
#N/A for option 1 but seems to work for 2,3 and 4, can someone tell me where 
I'm going wrong

=LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})

The AU17 cell has the following formula in it, and it works - this is for VAT
=IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))

Many Thanks for your help
0
Utf
2/24/2010 4:08:04 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

10 Replies
916 Views

Similar Articles

[PageSpeed] 49

Remove the quotations marks around the 1 in AU17's formula:
=IF(VC1="U",1, IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))


-- 
Best Regards,

Luke M
"Colette" <Colette@discussions.microsoft.com> wrote in message 
news:4E549FD8-B906-4F04-8413-81E42AD9CFB8@microsoft.com...
> I'm trying to use the following LookUp function but it keeps on coming up 
> as
> #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me 
> where
> I'm going wrong
>
> =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
>
> The AU17 cell has the following formula in it, and it works - this is for 
> VAT
> =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
>
> Many Thanks for your help 


0
Luke
2/24/2010 4:35:33 PM
Remove all the quotes from around any numbers.

>=IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))

=IF(VC1="U",1,IF(VC1="Z",2,IF(VC1="E",3,IF(VC1="P",4))))

>=LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})

=LOOKUP(AU17,{1,2,3,4},{0.175,0,0,0.05})

Alternative to LOOKUP:

=CHOOSE(AU17,0.175,0,0,0.05)

-- 
Biff
Microsoft Excel MVP


"Colette" <Colette@discussions.microsoft.com> wrote in message 
news:4E549FD8-B906-4F04-8413-81E42AD9CFB8@microsoft.com...
> I'm trying to use the following LookUp function but it keeps on coming up 
> as
> #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me 
> where
> I'm going wrong
>
> =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
>
> The AU17 cell has the following formula in it, and it works - this is for 
> VAT
> =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
>
> Many Thanks for your help 


0
T
2/24/2010 4:38:35 PM
Your problem is the quote marks around the "1". Quotes make the cell text. 
Without quotes it's a number, and you need a number in your Lookup 
statement. So change AU17 to:
=IF(VC1="U",1,IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,""))))
I also changed your last IF statement to return nothing ("") if the 
condition is not met. Otherwise you would get FALSE.
The fact that there are spaces in the IF statement shown tells us you 
manually typed the formula into your e-mail. This is fraught with error. 
Always cut and paste your formula, to avoid typing errors.

Finally, it's very likely your Lookup formula should be:
=LOOKUP(AU17,{1,2,3,4},{.175,0,0,0.05})

Regards,
Fred

"Colette" <Colette@discussions.microsoft.com> wrote in message 
news:4E549FD8-B906-4F04-8413-81E42AD9CFB8@microsoft.com...
> I'm trying to use the following LookUp function but it keeps on coming up 
> as
> #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me 
> where
> I'm going wrong
>
> =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
>
> The AU17 cell has the following formula in it, and it works - this is for 
> VAT
> =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
>
> Many Thanks for your help 

0
Fred
2/24/2010 4:47:11 PM
Colette -

You had 1 being entered as text into AU17.  Try this:

=IF(VC1="U",1, IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))

-- 
Daryl S


"Colette" wrote:

> I'm trying to use the following LookUp function but it keeps on coming up as 
> #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me where 
> I'm going wrong
> 
> =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
> 
> The AU17 cell has the following formula in it, and it works - this is for VAT
> =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> 
> Many Thanks for your help
0
Utf
2/24/2010 5:03:01 PM
Thanks again for all suggestions...I'd been tearing my hair out for something 
that was 'staring me in the face'

Colette

"Colette" wrote:

> I'm trying to use the following LookUp function but it keeps on coming up as 
> #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me where 
> I'm going wrong
> 
> =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
> 
> The AU17 cell has the following formula in it, and it works - this is for VAT
> =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> 
> Many Thanks for your help
0
Utf
2/25/2010 10:25:01 AM
Thanks Daryl S

Colette

"Daryl S" wrote:

> Colette -
> 
> You had 1 being entered as text into AU17.  Try this:
> 
> =IF(VC1="U",1, IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> 
> -- 
> Daryl S
> 
> 
> "Colette" wrote:
> 
> > I'm trying to use the following LookUp function but it keeps on coming up as 
> > #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me where 
> > I'm going wrong
> > 
> > =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
> > 
> > The AU17 cell has the following formula in it, and it works - this is for VAT
> > =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> > 
> > Many Thanks for your help
0
Utf
2/27/2010 5:34:01 PM
Many Thanks T. Valko

Colette

"T. Valko" wrote:

> Remove all the quotes from around any numbers.
> 
> >=IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> 
> =IF(VC1="U",1,IF(VC1="Z",2,IF(VC1="E",3,IF(VC1="P",4))))
> 
> >=LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
> 
> =LOOKUP(AU17,{1,2,3,4},{0.175,0,0,0.05})
> 
> Alternative to LOOKUP:
> 
> =CHOOSE(AU17,0.175,0,0,0.05)
> 
> -- 
> Biff
> Microsoft Excel MVP
> 
> 
> "Colette" <Colette@discussions.microsoft.com> wrote in message 
> news:4E549FD8-B906-4F04-8413-81E42AD9CFB8@microsoft.com...
> > I'm trying to use the following LookUp function but it keeps on coming up 
> > as
> > #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me 
> > where
> > I'm going wrong
> >
> > =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
> >
> > The AU17 cell has the following formula in it, and it works - this is for 
> > VAT
> > =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> >
> > Many Thanks for your help 
> 
> 
> .
> 
0
Utf
2/27/2010 5:35:01 PM
Many Thanks Luke

Colette

"Luke M" wrote:

> Remove the quotations marks around the 1 in AU17's formula:
> =IF(VC1="U",1, IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> 
> 
> -- 
> Best Regards,
> 
> Luke M
> "Colette" <Colette@discussions.microsoft.com> wrote in message 
> news:4E549FD8-B906-4F04-8413-81E42AD9CFB8@microsoft.com...
> > I'm trying to use the following LookUp function but it keeps on coming up 
> > as
> > #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me 
> > where
> > I'm going wrong
> >
> > =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
> >
> > The AU17 cell has the following formula in it, and it works - this is for 
> > VAT
> > =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> >
> > Many Thanks for your help 
> 
> 
> .
> 
0
Utf
2/27/2010 5:35:01 PM
Many Thanx Fred

Colette

"Fred Smith" wrote:

> Your problem is the quote marks around the "1". Quotes make the cell text. 
> Without quotes it's a number, and you need a number in your Lookup 
> statement. So change AU17 to:
> =IF(VC1="U",1,IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,""))))
> I also changed your last IF statement to return nothing ("") if the 
> condition is not met. Otherwise you would get FALSE.
> The fact that there are spaces in the IF statement shown tells us you 
> manually typed the formula into your e-mail. This is fraught with error. 
> Always cut and paste your formula, to avoid typing errors.
> 
> Finally, it's very likely your Lookup formula should be:
> =LOOKUP(AU17,{1,2,3,4},{.175,0,0,0.05})
> 
> Regards,
> Fred
> 
> "Colette" <Colette@discussions.microsoft.com> wrote in message 
> news:4E549FD8-B906-4F04-8413-81E42AD9CFB8@microsoft.com...
> > I'm trying to use the following LookUp function but it keeps on coming up 
> > as
> > #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me 
> > where
> > I'm going wrong
> >
> > =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
> >
> > The AU17 cell has the following formula in it, and it works - this is for 
> > VAT
> > =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
> >
> > Many Thanks for your help 
> 
> .
> 
0
Utf
2/27/2010 5:35:01 PM
You're welcome!

-- 
Biff
Microsoft Excel MVP


"Colette" <Colette@discussions.microsoft.com> wrote in message 
news:A58E73D1-9833-4E34-AEF1-742D89E02B55@microsoft.com...
> Many Thanks T. Valko
>
> Colette
>
> "T. Valko" wrote:
>
>> Remove all the quotes from around any numbers.
>>
>> >=IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
>>
>> =IF(VC1="U",1,IF(VC1="Z",2,IF(VC1="E",3,IF(VC1="P",4))))
>>
>> >=LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
>>
>> =LOOKUP(AU17,{1,2,3,4},{0.175,0,0,0.05})
>>
>> Alternative to LOOKUP:
>>
>> =CHOOSE(AU17,0.175,0,0,0.05)
>>
>> -- 
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Colette" <Colette@discussions.microsoft.com> wrote in message
>> news:4E549FD8-B906-4F04-8413-81E42AD9CFB8@microsoft.com...
>> > I'm trying to use the following LookUp function but it keeps on coming 
>> > up
>> > as
>> > #N/A for option 1 but seems to work for 2,3 and 4, can someone tell me
>> > where
>> > I'm going wrong
>> >
>> > =LOOKUP(AU17,{1,2,3,4},{".175","0","0","0.05"})
>> >
>> > The AU17 cell has the following formula in it, and it works - this is 
>> > for
>> > VAT
>> > =IF(VC1="U","1", IF(VC1="Z",2,IF(VC1="E",3, IF(VC1="P",4,))))
>> >
>> > Many Thanks for your help
>>
>>
>> .
>> 


0
T
2/27/2010 8:28:57 PM
Reply:

Similar Artilces:

Help Needed ... Probably simple for you gurus ... locking cell after data entered and
positioning next cell after enter is hit I am very computer illiterate and have searched and experimented for 2 days with limited success here is currently what the macro does when data is entered into a cell that cell is filled with the color green....simple...and works also there is 3 different columns with data being entered...A....B....C....after data is entered in C it automatically puts the current date in the corresponding cell in column D....that is somewhat ok...would like it to time stamp it also here is features that I would like to add Once data is entered to a cell I would l...

Help, can't shrink to fit so art prints on 1 page!
Working on a large banner, and want to share it with my team for review. Original file is 15mg, too large to send, and making a .pdf results in 45 pages of tiled images. Other desktop publishing software allows you to select a "fit to one page" or "scale" option so your image is reduced to one legal or letter sized sheet of paper. I can't even print this out to walk around and show my co-workers for comment. So - making a .pdf doesn't work, selecting Reduce then Fit to Paper Size won't work, asking to scale this to 20% won't work, printing to Offic...

HELP! Design Review & Risk Management topics (in ASP projects) required
Hi, I have to take 2 one hour sessions on the following topics: * Project Design Review * Project Risk Management Can you please recommend any topics/examples/case studies for the same? Any help will be much appreciated. On 9/6/2010 8:12 AM, gangestech wrote: > Hi, > > I have to take 2 one hour sessions on the following topics: > > * Project Design Review > * Project Risk Management > > Can you please recommend any topics/examples/case studies for the same? > > Any help will be much appreciated. > <http://www.dofactory.com/Fra...

Problem cut-n-paste function
I'm having a bizarre problem cut-n-pasting a very simple calculation (ie = A1 � B1) in C1 down the column (ie C2 to Cn). When I cut-n-paste the function in C1, value that displays is the same as the source cell. If I click on the target cell, the correct cells are highlighted and if I hit the enter button, the formula calculates as expected. What is going on? What do I have to do to force the formula to auto calculate? Turn on Automatic Calculation <g>. You do that at Tools/Options/Calculation. On 27 Sep 2004 18:56:34 -0700, jsausten@hotmail.com (Stephen Miller) wrote: >I'm...

Help! This is serious!
All of a sudden when I try to open an .xls file, it comes up with a page full of little "y"'s. What is wrong? I have data that I need to recover! I hope you have a backup. And keep your backups safe and offline. http://www.mvps.org/dmcritchie/excel/backup.htm Check your font in the fontbox Right click on the sheet tab, view code, anything in there? Tools, Autocorrect check the righthand column for y's Does this happen with just one worksheet, the entire workbook, all workbooks, all MS Office programs like Excel and MS Word. Does it happen on ne...

Help with Dates
Hi all, I have a table with field name "ConnectionDate". I want to create a form with ComboBox that will show the "ConnectionDate" as month and year only. The value the user will choose will be a criteria for a query. Please help. TIA, Tom ?Format(Date,"mmyyyy") would return 112007 so, SELECT Format(ConnectionDate,"mmyyyy") AS ConnectDate FROM SomeTable -- Dave Hargis, Microsoft Access MVP "Tom" wrote: > Hi all, > > I have a table with field name "ConnectionDate". > I want to create a form with ComboBox tha...

Event ID 125
I have received an Event ID 125 on an Exchange 5.5 server. Along with this I have an ID Error #193, 1005 7 and 100 amonst others. Is it possible that during a backup in schedule+ for a client on the client's machine, that the procedure corrupted the EDB.log or any other file? If so, should I be using Microsoft Base Article #275602 to repair. At this point, my Echange server is down. Thanks. Hello Deb Based on the limited information; the 275602 XADM: Microsoft Exchange Server Information Store May Stop After a http://support.microsoft.com/?id=275602 would be a recovery method. Did y...

Help, No pictures in Pub 2003
I installed Pub 2003 and none of my graphics are showing on my document. Does anyone know how I can fix that? Thanks Ed looks left. Ed looks right. No-one is there. Furtively, Ed picks up a note from Xeroid <lnerbonne@cogeco.ca>. On it is written: > I installed Pub 2003 and none of my graphics are showing on my > document. Does anyone know how I can fix that? View > Pictures...? -- Ed Bennett - MVP Microsoft Publisher http://www.mvps.org/the_nerd/ Before reading this message, view the disclaimer: http://mvps.org/the_nerd/disclaim.htm when I open a Pub made file fro...

Pivot Table Help #3
I have a lot of data that I am trying to analyze with a pivot table and am not sure how to go about it. Columns are (1) District (2) Store # (3) 2003 Score - these are #s or text ("incomplete") (4) 2004 Score - these are #s or text ("incomplete") For each district, I am trying to find out 3 things: (1) % of stores incomplete (2) Average score for 2003 & 2004 - I've got this one working properly (3) % change between 2003 & 2004 I can successfully analyze the data in a spreadsheet but there is too much to go through and thought a pivot table was the way to ...

IFD install needed help
Hi, After facing many errors and difficulties during the CRM 4.0 installation I successfully installed the product. Now I am trying to install CRM as IFD. I want to install IFD without any problems So I have some questions. What is the SDK root domain and web application root domain mean? Is the below config file format is alone enough for IFD installation. Is there anything else i need to look up.?? I went through the MSDN documentation. Can anyone guide tell me how and what configurations i should use to install IFD successfully. <CRMSetup> <Server> <ifdsettin...

Need to remove help compile in project
Can someone tell me how to remove the help build process from a project? Thanks What does this mean? You want to remove part of the build? If yes, just remove those files from project. -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "mike" <nospamplease.com> wrote in message news:%236ooDIkGHHA.1468@TK2MSFTNGP04.phx.gbl... > Can someone tell me how to remove the help build process from a project? > Thanks > > I've tried removing the help files but when I build, the help compiler is still invoked. The project show a couple of .rtf files in the dependenc...

Need Help Troubleshooting Report Manager
Here is my situation. I can=92t get to Report Manger via IE. IE just displays the =93Internet Explorer cannot display the webpage=94 error message. Details: OS is Server 2008 Standard. I=92m running a standalone computer =96 not connected to the internet. I=92ve installed MS Loopback Adapter. I=92ve installed SQL Server Reporting Services and it=92s running ok. I verified by going to Services. Status is Started, Startup Type is Automatic. The account I=92m logged in as is a member of the Administrators Group. Windows Firewall is off for all profiles. Under Network Connections ...

Report Writer Dater Function
Hello: Does anyone know how to create a restriction in Report Writer to show the most recent date? I want to obtain the most recent date for the Apply to Document Date field in the body of my report. This field is in the Apply Open File (RM20201). Thanks. childofthe1980s ChildOfThe1980s, I would be more than glad to help if you could further explain what report in particular is this for, is it an aging? If so, would you like the most recent apply to date to display on a summary aging? Not sure I am following what you need. MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Busines...

FORMATING COLUMNS..... HELP
I need to format columns to allow only 7 characters and the rest of the data to go into column B -- JTEFUN "JTEFUN" <JTEFUN@discussions.microsoft.com> wrote in message news:6C5C7A99-E83F-430E-9576-6D1DB57B9311@microsoft.com... >I need to format columns to allow only 7 characters and the rest of the >data > to go into column B > -- > JTEFUN > If you mean that if a user types a lot of data into the one cell and that when they reach 7 characters the rest of the data is automatically inserted into the next cell, then I don't think you can do that....

Running Office 2001 on Mac OS 10.2, help
This might be a dumb question, but I don't want to screw things up. I was running Mac OS 9.0.4 and I downloaded OS 9.1, 9.1.2, 9.2.2 and then the new 10.2. However, all my software is still in the 9.1 classic. I want to use it all in the new OS 10.2. Will Office 2001 Academic Edition work in OS 10.2? Do I need to uninstall it in OS 9.1 first, then install it is OS 10.2? Or, can I just drag and drop it on the 10.2 desktop or in the applications folder? I have a lot of other expensive softwares in OS 9.1 that I don't want to have to upgrade, but need to be able to use in OS 10.2. Wi...

HELP with Office 2004 not loading after installing Adobe Acrobat 7.
Hi, Word, Excel and Powerpoint won�t launch anymore after installing Adobe Acrobat 7. I checked on office/startup and the three folders are empty. All I get is window telling me that app couldn�t launch.. Error reporting. Is there a way to fix this? I don�t want to reinstall OSX. I have uninstalled and reinstalled Office several times to no avail. Entourage launches fine. Thanks, AJ There are troubleshooting techniques linked from this page, work through them: http://www.mcgimpsey.com/macoffice/ see General Troubleshooting and Troubleshooting for Office 2004 If they get to the splash sc...

Help: message "Requesting data from Exchange Server"
Has anyone figure out why we receive the pop-up message "Requesting data from Exchange Server" when we try to open an email in outlook? We are using Exchange 2000. Is there a parameter we can change to fix this issue? "Kenny" <anonymous@discussions.microsoft.com> wrote: >Has anyone figure out why we receive the pop-up >message "Requesting data from Exchange Server" when we >try to open an email in outlook? We are using Exchange >2000. > >Is there a parameter we can change to fix this issue? Depends to a greater or lesser extent ...

Remove records from lookup
Not sure if this is possible but I would like to remove all records except the account records from the look up records dropdown menu of the appointment entity. The associated schema is regardingobjectid and the label is regarding. I see the other entities listed under relationships but there is no option to delete. Is there a way to create a new lookup and have it added to my appointment form? Thanks. There is no supported way to change this. The system is setup to allow you to set appointments that are related to specific records (Opportunities, Quotes, Cases, etc) and it will then ro...

Drill Down Function
I'm trying to create a function that will open a detail form based on a field value in a master form. I can do this using a private sub, but I hate replicating the same private sub over and over again each time I want to drill down from a different form or control. I also like being able to run a function directly from the On Double Click event of any given control and form without first having to go to a private sub. The function would have to be told the name of the detail form to open, the name of the key field in the detail form, and the value to search for. Here...

Outlook help
Hello. After years of using Outlook on my Windows XP machine, now I get the following error: Cannot start Microsoft Office Outlook. Unable to open the Outlook window. The set of folders could not be opened. The server is not available. Contact your administrator if this condition persists. Can anyone help? Where is the actual data kept? Can I retrieve it? Can you open Outlook in Safe Mode by using the /Safe switch? If you need help using Outlook command line switches, look here: http://support.microsoft.com/default.aspx?scid=kb;en-us;296192 -- Jocelyn Fiorello MVP - Outlook ...

SOP Document Lookup Error
Whenever we try using the document number lookup on the Sales Transaction Entry screen in GP8, we get the following message once we click the magnifying glass: Unhandled script exception: Index 0 of array 'Type Name' is out of range in script 'Document_Scroll SCROLL_FILL'. Script terminated. EXCEPTION_CLASS_SCRIPT_OUT_OF_RANGE SCRIPT_CMD_INDEX Does anyone have any ideas on how to clear this up? This pops up as soon as you click on the magnifying glass, then once you click ok, it pops up 2 more times. Do a query against table SOP10100 and look for any values in the SOP...

SERIES function disappear
I can't use SERIES in Excel 2007 (err msg, input function not correct) even i cant find SERIES function at "Insert function" dialog i disable Marco in Excel 2007, is it related? Pls Help, Thank you What were you expecting SERIES to do for you as a worksheet function? In Excel 2003, SERIES didn't exist in a worksheet, but only in a chart. -- David Biddulph "Vimm" <Vimm@discussions.microsoft.com> wrote in message news:1FA6C85E-A9F2-471F-9629-8ED8B9901CB8@microsoft.com... >I can't use SERIES in Excel 2007 (err msg, input function not correc...

need help with list box?
Hi I have a huge table of about 20000 records. how can I restrict entry for a few columns. I am new to excel programming. For example. I have a list of colors (red, green, blue) that I want to go under the Color column. how can I allow the user to click on a pulldown or list box similar to ms access for each cell. thanks in advance. Hi you could use 'Data - Validation'. See: http://www.contextures.com/xlDataVal01.html >-----Original Message----- >Hi > >I have a huge table of about 20000 records. how can I restrict entry for a >few columns. >I am new to exc...

Help! Can't Restore my "Old" Money 2005 Backup
Help! Can't Restore my "Old" Money 2005 Backup. Windows 2000 replaced by Windows XP Home on C:\Drive. D:\Drive contains data and Backup only. PC is on a wired Home Network . I recently upgraded from Windows 2000 Pro to Windows XP Home. I wiped the C: Drive clean (formatted) and did a "Fresh" install of Windows XP Home. I reinstalled Microsoft Money 2005 Deluxe, then tried to restore my "old" 2005 Money Backup file (My Money Backup.mbf) from both D: Drive and USB thumbdrive. The Restore shows a default location ..."C:\Program Files \My Money.mny&quo...

Pls help me out.
Greetings to all. i am a new Mac user. i inherited a ibook loaded with MsOffice for Mac that is in german. do you think i can reset the language to english without having to re-install the whole sofware? if so, how? thank you all so much! On 10/5/04 4:16 PM, in article 2ee7bd29.0410042316.72004f36@posting.google.com, "luc" <tchinlai@yahoo.com> wrote: > Greetings to all. > > i am a new Mac user. i inherited a ibook loaded with MsOffice for Mac > that is in german. > do you think i can reset the language to english without having to > re-install the whole s...