![]() |
| |||||||
| Computer Juice raffle - Win PC hardware of your choice worth £500 / €680 / $1000 - Enter HERE! |
| |
Computer Juice - Forums - Excel Formula - VLookups :s |
![]() |
| | Thread Tools |
|
#1
| ||||
| ||||
Excel Formula - VLookups :sHi, 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 |
| |
|
#2
| ||||
| ||||
Excel Formula - VLookups :sHi 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. |
|
![]() |
| Thread Tools | |
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Formula Help | Jonathon28 | Office Suites & Applications | 6 | 22-02-2008 02:36 PM |
| Excel help | Dj Ram | Office Suites & Applications | 2 | 19-02-2008 05:22 PM |
| =IF formula | Jonathon28 | Office Suites & Applications | 5 | 17-02-2008 03:10 PM |
| Asus Striker 2 Formula, some questions | codymackay | CPUs, Motherboards & RAM | 5 | 10-02-2008 11:24 PM |
| Excel formula between language versions? | PranX | Office Suites & Applications | 0 | 17-09-2007 04:41 PM |
| Powered by vBulletin® Copyright ©2000 - 2008 Jelsoft Enterprises Ltd. SEO by vBSEO ©2008, Crawlability, Inc. |