Results 1 to 18 of 18

Vlookup and data validation I think thats what i need not sure any help would be great

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-24-2017
    Location
    Vic Australia
    MS-Off Ver
    Office 365 Apps for enterprise
    Posts
    147

    Vlookup and data validation I think thats what i need not sure any help would be great

    Good afternoon everyone

    I have been working on this sheet for about a month and so far its working
    now I have found that there have been a lot of changes and now the simple vlookup does not do the trick I need it to do

    I have drivers that come to our warehouse

    and I have set it up so when I type in there rego in to Row S
    =IFERROR(VLOOKUP(S23,Drivers!A:C,2,FALSE),"") drivers name
    =IFERROR(VLOOKUP(S23,Drivers!A:C,3,FALSE),"") drivers phone number

    S23 starts at S2 and goes to S62 only 1 needs to be fixed and I just use the same code for each other truck

    fills it self out from drivers sheet in side the work book

    there are now over 380 drivers names with regos

    and now a few of the drivers are changing trucks regos

    so now when I driver turns up with a rego already in the sheet it shows the first person on the list

    every 3 days I update the sheet with new drivers where there regos are not in the sheet or if there a different name on there so I have records

    I would like a way so that when i type in a rego if there is more then 1 person with a match rego

    a list will pop up with the names of the drives that have the same matching rego so I can click the right name and then phone number will also change

    I have to use the rego as the point cause we have over 50 trucks a day come on site the rego is how our warehouses nows which truck to load up other wise using a mobile number would be the easiest way

    I tried to use the build in file uploader and did not work so upload to http://www.filedropper.com/10817


    I have spent a few hours looking up youtube and nothing that I can fix will fix this problem and I'm not even sure excel would be able to do this

    any help would be Great

    JustinwB
    Attached Files Attached Files
    Last edited by justinwb; 09-25-2017 at 12:33 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vLookup & Data Validation
    By Phyxius in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2016, 10:24 AM
  2. Replies: 7
    Last Post: 03-06-2015, 01:53 PM
  3. Help with Vlookup & Data Validation
    By woodburner in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2014, 12:48 PM
  4. Replies: 9
    Last Post: 11-26-2012, 12:46 AM
  5. Data Validation and VLOOKUP
    By jchesner in forum Excel General
    Replies: 1
    Last Post: 03-29-2012, 12:46 PM
  6. Using Vlookup & Data Validation
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-11-2012, 03:17 PM
  7. VLookup/Data Validation
    By tdemartino@qosina.com in forum Excel General
    Replies: 1
    Last Post: 05-09-2006, 05:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1