|
|
#1
23rd Apr 2008, 10:18
|
|||
|
|||
|
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
|
||||||||||||
|
||||||||||||
|
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...
|
