lesser-equity

Magazine
Go Back   Computer Juice > Computer Software > Office Suites & Applications

Register


Default Excel Formula - VLookups :s

Hi, I have a spreadsheet I have created however, the Vlookups i have entered don't seem to be working. Basically, on the 'Jobs' sheet (see attachment for file), I want to be able to type in the Forename OR surname of the customer and the spreadsheet automatically fills in the ...


Reply
 
Thread Tools
  #1  
Old 23rd Apr 2008, 10:18
Member Group
 
Posts: 95
Default Excel Formula - VLookups :s

Hi, I have a spreadsheet I have created however, the Vlookups i have entered don't seem to be working.

Basically, on the 'Jobs' sheet (see attachment for file), I want to be able to type in the Forename OR surname of the customer and the spreadsheet automatically fills in the ID and forename/Surname fields.

Any help would be appreciated on this one!

Many thanks in advance!

Jon.C
Attached Files
File Type: xls Spreadsheet.xls (37.0 KB, 20 views)
  #2  
Old 1st May 2008, 12:14
Malware Group
 
Skill Level: Advanced
Posts: 348
Default Excel Formula - VLookups :s

Hi

The syntax for your VLookup was a bit off. You can't refer to just a sheet name - you need to refer to a range or a named range. I named B1:C15 on the Customer sheet CustName. It now works fine. The correct formula is therefore

=VLOOKUP(B4,CustName,2,FALSE)

Spreadsheet re-attached.
Attached Files
File Type: xls VLookup Spreadsheet.xls (39.0 KB, 44 views)
__________________

My System: It's all mine...

Processor(s):
C2D E6750 2.66Ghz
Motherboard:
Gigabyte P35C-DS3R
RAM Memory:
2 x 1Gb Corsair DDR2 XMS2 PC26400
Graphics Card(s):
GeForce 8600GT
Sound Card:
Creative X-Fi
Hard Drive(s):
Maxtor 320Gb
Optical Drive(s):
Pioneer DVD-RW
Case / PSU:
Antec 900 / Antec TruPower Trio 650
Cooling:
Various Antec + Zalman 92mm
Network / Internet:
ASUS Router/VirginMedia
Monitor(s):
LGL226WQ 22" Widescreen
Operating System(s):
XP Pro SP3
Reply

Donate

Register

Bookmarks

Similar Threads
Thread Thread Starter Forum Replies Last Post
Asus Maximus II Formula PC build mizsua CPUs, Motherboards & RAM 7 9th Jan 2009 16:44
Help with Excel formula please robbie73 Office Suites & Applications 2 10th Sep 2008 11:00
Excel Formula Help Jonathon28 Office Suites & Applications 6 22nd Feb 2008 08:36
=IF formula Jonathon28 Office Suites & Applications 5 17th Feb 2008 09:10
Asus Striker 2 Formula, some questions codymackay CPUs, Motherboards & RAM 5 10th Feb 2008 17:24
Thread Tools




Arabic Bulgarian Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch English Finnish French German Greek Hebrew Hungarian Italian Japanese Korean Latvian Lithuanian Norwegian Polish Portuguese Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish Ukrainian

Copyright ©2006 - 2009 Computer Juice.

Powered by vBulletin® Copyright ©2000 - 2009 Jelsoft Enterprises Ltd. SEO by vBSEO ©2009, Crawlability, Inc.