vlookup help needed

[rodgerdooter]

i need help putting in a vlookup formula please

i use a despatch log to record the vehichles leaving my depot every day ( time , pallets , etc etc )

we now for security reasons have to record the driver and his drivers licence number

i have all the names and licence numbers saved on my first sheet and am using them list style on my second sheet

is there a way i can select the driver and the licence number will automatically fill ??

i have posted an example

[popipipo]

Try this formula:

=IFERROR(VLOOKUP(I1,names!$N$2:$O$21,2,0),"")

[Pete_UK]

As you haven't got any headings, it's not very clear. Which column do you want to put the names in, and where does the licence number go? Do you want to select the driver from a drop-down list?

Pete

[rodgerdooter]

sorry , ive copied some headers in now

the drivers section is column I , which is a drop down box selection from the names tab
the licence numbers are going in column J , which is also a drop down selection from the names tab

i would like it if the the drivers licence number would fill automatically when a driver is selected

[Pete_UK]

First of all, set up a named range for your names, as follows:

Select the cells N1 to N16 on the names sheet, then click on the Formulas tab of the Ribbon then in the Defined Names group click on Create from Selection, ensure Top row is checked and click OK. This will use the entry from N1 as the name. Then on the data tab, select the cells I2 to I26, click on the Data tab | Data Validation, then select List under Allow and in the Source box you should type =Shunter

Then in J2 you can enter this formula:

=IFERROR(VLOOKUP(I2,names!$N$2:$O$16,2,0)&"","")

and copy this down.

Hope this helps.

Pete

[rodgerdooter]

great
thanks for your help guys