lesser-equity

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



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, 6 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, 11 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

Please support this forum, donate towards our running costs.
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel question HistoryGirl Office Suites & Applications 1 8th Apr 2008 08:09
Excel Formula Help Jonathon28 Office Suites & Applications 6 22nd Feb 2008 07:36
Excel help Dj Ram Office Suites & Applications 2 19th Feb 2008 10:22
=IF formula Jonathon28 Office Suites & Applications 5 17th Feb 2008 08:10
Asus Striker 2 Formula, some questions codymackay CPUs, Motherboards & RAM 5 10th Feb 2008 16:24

Tags
excel, formula, vlookups

Bookmarks
Thread Tools



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

Copyright ©2006 - 2009 Computer Juice.

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