|
| Computer Juice Magazine |
|
|||||||
| Register | Site Spy | Member List | Donate | Unanswered Posts | Search | Today's Posts | Mark Forums Read | Forum Rules |
 |
|
|
Thread Tools |
|
#1
23rd Apr 2008, 10:18
|
|||
|
|||
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 |
|
#2
1st May 2008, 12:14
|
||||||||||||
|
||||||||||||
|
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. My System: It's all mine...
|
|
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 | |
|
|
