Computers & Internet - 20 September 2007

Ok, so I have a list of serial numbers in one column, the first one or two numbers of every serial relate to information on another page; every serial number starting with 2 is a certain type of truck, every serial number starting with 16 is another type of truck. (EX: 16483 = 16, 2005 = 2). I just want the lookup to match the first one or two digits of hte cell value to the lookup information.

My formula looks like:

=IF(ISERROR(VLOOKUP(J2,Sheet1!$G$10:$J$28,3,FALSE)),"",VLOOKUP(J2,Sheet1!$G$10:$J$28,3,FALSE)*(Sheet2!F2))

I haven't been able to successfully use a wildcard to pick these up. Can anyone help?

Thanks

2007-09-20 05:53:50 · 9 answers · asked by Sapper 2 in Programming & Design

The words plus image like a smiley face takes too much space.

2007-09-20 05:52:14 · 5 answers · asked by marie m 2 in Other - Computers

2007-09-20 05:48:19 · 9 answers · asked by D. 2 in Desktops

can i make skype play through my headphones but make my computer play through the speakers?

2007-09-20 05:45:28 · 2 answers · asked by ce3sparky 2 in Add-ons

my pc won't turn off i have to unplug the thing, i have trouble getting on the internet,got lucky today!it's running slow,i have a update manager wanting to update a sonic manager can't get it off i have a used windows xp,should i do a pc cleaner? whats a good fast cleaner download,i'm on my knees begging for help,i think it's ready to crash,i've tried a system restore,tried a disk cleanup,tried to defrag,still happening WHAT"S WRONG! i never get any answers on here am i asking right thank u all

2007-09-20 05:41:33 · 7 answers · asked by mommabird 2 in Desktops

At my job my printer spits out papers that read

PCL XL error Warning: IllegalMediaSource

What does that mean? And how can I fix it. It uses a lot of paper and is wasting a lot of unccessary money... Please help!

2007-09-20 05:41:32 · 3 answers · asked by Rayve 2 in Printers

i heard something some ram refresh it self and some you have to turn off and on is that due to virtual memory i how can i increase that because when i under performance there is available memory and cache and system cache is always more after running for while few hours

2007-09-20 05:41:06 · 3 answers · asked by Anonymous in Other - Computers

The computer is six years old.

2007-09-20 05:39:38 · 5 answers · asked by beard 1 in Desktops

i tried block https but also block certain web sites, what do i need to do to block block msn messenger exclusively?

2007-09-20 05:38:22 · 7 answers · asked by Ivan CB 1 in Computer Networking

I am downloading a program, but everytime i go to setup it sais,

'Instalation cannot continue until the following applications are closed'

Internet explorer

I didnt have it open, and when i pressed try again, it keeps showing the same thing.How do i close it?
BTW when i download it, i dont have IE on the bottom blue dash.

2007-09-20 05:38:08 · 1 answers · asked by Anonymous in Software

I have Pen4 2.66ghz with 1gig ddr2 ram 533mhz 300gig ide harddrive some how after leaving it on for while half day or so computer gets so slow i run symantec trial anti-virus i dont know if setting is wrong or i just need better processor and more ram please help

2007-09-20 05:22:57 · 20 answers · asked by Anonymous in Other - Hardware

I'm a novice computer user. I'm looking to switch over to windows xp 64bit. Because the processor i've got is an AMD AM2 64 X2.

Does the 64bit OS provide the same functionality as the regular? Will i get better processing power?

I will mainly use this computer as the house multimedia center to store all my music, movies, and other files that the other computers can pull from around the house via networking. Also its plugged into my HDTV for the main entertainment system.

Also, the price is that same for the two OS's.

Would this be a good option? Mainly just to utilize my 64bit Processor?

2007-09-20 05:17:16 · 2 answers · asked by Scottie"T" 5 in Software

2007-09-20 05:06:44 · 6 answers · asked by Anonymous in Security

They are both the latest versions so will this inability resolve itself with the purchase of both programs?

2007-09-20 05:05:21 · 3 answers · asked by E J 3 in Programming & Design

do i use lower case or higher case commas ect

2007-09-20 04:59:05 · 3 answers · asked by Anonymous in Programming & Design

I don't want to become a C programmer, but remember enjoying the structured yet fairly comprehensible syntax of Pascal. What choices are available today - the ability to code for Windows and preferably other GUI/OSs a must.

As an aside, if one was to go back to basics with an old copy of Borland Turbo Pascal 5.x, would it be feasible and practicable to write code that makes use of the Windows API?

2007-09-20 04:49:22 · 2 answers · asked by Raygun 2 in Programming & Design

2007-09-20 04:45:47 · 6 answers · asked by Anonymous in Security

I recently purchased a 2007 Norton antivrus disc, do I need to install this disc or take it back to vendor?

2007-09-20 04:43:12 · 3 answers · asked by Vonda A 1 in Security

i just recently inherited a computer from my former grandfather and he has a lot of websites blocked and since he's no longer around i can't ask him how to unblock them if anyone knows what i can do to get my computer to let me use those websites please let me know
thank you

2007-09-20 04:36:08 · 9 answers · asked by manda g 2 in Security

I have to buy a computer and printer this weekend. I have never bought these items on my own.

What are the key items to look for in a computer?

Also, where are good stores to buy these items? I really don't have time to order these items online.

2007-09-20 04:28:58 · 8 answers · asked by Stareyes 5 in Desktops

Does a 64bit processor really make a difference if i'm not using a 64bit OS?

2007-09-20 04:28:14 · 2 answers · asked by Scottie"T" 5 in Other - Computers

I'm looking to use windows xp 64 pro for my main hub computer in my home. will home versions of windows xp (not 64) still work on the network if the if the 64 is my main focal point for files and printers?

2007-09-20 04:23:56 · 3 answers · asked by Scottie"T" 5 in Computer Networking

I've tryed lots of programs, but would like to do it this way,

2007-09-20 04:12:20 · 4 answers · asked by John v 3 in Laptops & Notebooks

Vista running on a Vaio and Xp running on a DELL latitide. Can I use the DELL's installation CD to install XP on the Vaio?
I want to exchange OS.

2007-09-20 04:11:26 · 7 answers · asked by Anonymous in Software

I wont ask for a specific question cause many of u r going to tell me that its a matter of choice, however, on ur opinion which processor works better on windows based system and at wich point are they independent of any other specifications:

Intel Core 2 Duo T7100 @1.8 GHz
or
AMD Turion 64 X2 TL-52 Dual Core @ 1.6 GHz


and an additional question, ¿what r the main differences between ATI's Radeon and NVidia vioa cards.

2007-09-20 04:11:13 · 6 answers · asked by Dexter H. 2 in Laptops & Notebooks

I will only be using this Apple for Internet browsing and word processing and Internet banking, so please can you tell me if I need to buy Internet security?

2007-09-20 04:10:54 · 4 answers · asked by Anonymous in Security

i did try with a Buffalo Mimo PCMCIA card with no success will I still be unsuccessful with the C&W Card?

2007-09-20 04:10:03 · 2 answers · asked by Anonymous in Computer Networking

SPECS
____________

Core 2 Duo T7300
Processor & Chipset:
Microprocessor Full Name: Intel® Core™ 2 Duo Processor T7300, Supports Enhanced Intel SpeedStep® Technology
Microprocessor Manufacturer: Intel®
Microprocessor Speed (GHz): 2
Number of Cores: 2
Frontside Bus (MHz): 800
Chipset Mobile: Intel® PM965 Express Chipset

RAM:
Memory Speed: (MHz) 667
Memory Type: DDR2 SDRAM (2x1024MB)
Max. Memory (MB): 2048
Memory Size (MB): 2048

Cache Memory:
L2 Cache (KB): 4096 Advanced Smart Cache

2007-09-20 04:00:38 · 4 answers · asked by Anonymous in Laptops & Notebooks

all pictures printed smaller than I wanted and am printing these out for my sons science project

2007-09-20 03:55:03 · 4 answers · asked by eagle 1 in Google

I am traveling outside the US and need to know if I'll be able to vpn into my work network or not. Are there any restrictions to using vpn internationally when in an internet cafe or such? Anyone know of anything that might cause a problem from using a public connection. I just need to be sure the vpn will work, i understand the security might be lowered since it's a public network. Thanks!

2007-09-20 03:47:41 · 8 answers · asked by jsssika 2 in Computer Networking