Sunday, March 6, 2016

Fast Solution to Error: Lookup or macro help

Lookup or macro help

Sheet1
A:A item (text)   B:B quantity    C:C unit     D:D lookup?           E: ?                    F ?
sugar                      2                 lb       (formula for cost)     (return store)     (return date)
Sheet2
A:A item   B:B unit    C:C cost   D:D  store  E:E total  F:F date
sugar          lb            .61            K              6.16           11/15/10
Sheet1 would now look like
A:A item (text)   B:B quantity    C:C unit     D:D lookup?           E: ?                    F ?
sugar                      2                 lb              1.22                     K                      11/15/10
match/find sheet1 A to sheet2 A if match multiply sheet2 C by sheet1 B (cost by quantity)
copy sheet2 D to sheet1 E
copy sheet2 F to sheet1 F
Thanks for your help

Keys to the Problem Lookup or macro help

Download SmartPCFixer to Fix It (Free)

D2: =if($B2<>"",vlookup($A2,Sheet2!$A:$F,3,False)*B2,"")
E2:  =if($A2<>"",vlookup($A2,Sheet2!$A:$F,4,False),"")
F2: =if($A2<>"",vlookup($A2,sheet2!$A:$F,6,False),"")
then drag fill down the columns D, E and F
--
Tom Ogilvy
note: If you receive an answer to your question - please mark that answer or answers so others know the question has been answered.

Manually editing the Windows registry

Manually editing the Windows registry to remove invalid MACHINE_CHECK_EXCEPTION keys is not recommended unless you are PC service professional. Incorrectly editing your registry can stop your PC from functioning and create irreversible damage to your operating system. In fact, one misplaced comma can prevent your PC from booting entirely!


Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

To manually repair your Windows registry, first you need to create a backup by exporting a portion of the registry related to MACHINE_CHECK_EXCEPTION (eg. Windows Operating System):

  • Click the Start button.
  • Type "command" in the search box... DO NOT hit ENTER yet!
  • While holding CTRL-Shift on your keyboard, hit ENTER.
  • You will be prompted with a permission dialog box.
  • Click Yes.
  • A black box will open with a blinking cursor.
  • Type "regedit" and hit ENTER.
  • In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
  • From the File menu, choose Export.
  • In the Save In list, select the folder where you want to save the Windows Operating System backup key.
  • In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
  • In the Export Range box, be sure that "Selected branch" is selected.
  • Click Save.
  • The file is then saved with a .reg file extension.
  • You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

Another Safe way to Fix the Problem: Lookup or macro help:

 

 

How to Fix Lookup or macro help with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed


Related: Icon Deleted Nd Required,Can't Boot Up On Windows 8 Recovery Disks,Windows Vista Service Pack 2 Updates,I Have Installed A Printer (WiFi) But Can Print Only Word Documents. When I Try To Print From Pdf Or Excell In Say Current Printer Is Not Available.,Spell-check Not Working Because Of Too Many "spelling Errors",How Can I Get Hotsync.exc Program Of Palm To Run On My Windows 7 Computer?,Windows 7 Will Only Start In Safe Mode!,Ie9 Object Error,Hi I Am Having An Issue With VSS,Printer Wont Respond, After A Different Printer Is Used For A 1-off Job
Read More: How to Fix Problem - Unable to install programs in Vista computer, get message as Windows installer is not installed properly?,How Can You Fix - windows 7 home premium recovery disc currrupted?,How to Fix - Where is the Help Menu in Windows 7??,Why does windows installer open each time I start Outlook Express? [Solved],Fast Solution to Error: Excel 2013 wont open up excel 2007 files,How to change to European time zone?,Windows 8.1 update failure,Folders create a runtime error on right click,Want to go wireless to use another web connection,Need help creating a tool

No comments:

Post a Comment