|
|
|||||||
|
 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 ...
|
 |
|
|
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...
|
|
|
|
| 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 | |
|
|
