+ Reply to Thread
Results 1 to 8 of 8

VLOOKUP to fill form from Choices

  1. 07-19-2023, 03:31 PM #1
    Roger50046
    Roger50046 is offline
    Registered User
    Join Date
    02-02-2016
    Location
    Worcester,UK
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    55

    VLOOKUP to fill form from Choices

    Hi Me again

    I have attached a sheet where i am looking for your help with where i believe VLOOKUP will work.

    But for the life of me i am stumped.

    If Goods are entered into A4 via a drop down menu, and the pack size of 20 or 30 is chosen, i would like the results from the prices matrix to show below in the respective code & units box below.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-19-2023, 03:57 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: VLOOKUP to fill form from Choices

    Set up your table like this:

    Please Login or Register  to view this content.
    Then use:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    If you leave the table as it is, you're going to struggle.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 07-19-2023, 04:01 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: VLOOKUP to fill form from Choices

    Here's the file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-19-2023, 04:11 PM #4
    Roger50046
    Roger50046 is offline
    Registered User
    Join Date
    02-02-2016
    Location
    Worcester,UK
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    55

    Re: VLOOKUP to fill form from Choices

    thanks TMS, i will give it a go.
    Reply With QuoteRegister To Reply
  5. 07-19-2023, 04:14 PM #5
    Roger50046
    Roger50046 is offline
    Registered User
    Join Date
    02-02-2016
    Location
    Worcester,UK
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    55

    Re: VLOOKUP to fill form from Choices

    Forgot to add Value as a line, i will try and work this out
    Reply With QuoteRegister To Reply
  6. 07-19-2023, 04:28 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: VLOOKUP to fill form from Choices

    That would be:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 07-20-2023, 09:03 AM #7
    Roger50046
    Roger50046 is offline
    Registered User
    Join Date
    02-02-2016
    Location
    Worcester,UK
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    55

    Re: VLOOKUP to fill form from Choices

    Thanks TMS
    Reply With QuoteRegister To Reply
  8. 07-20-2023, 10:00 AM #8
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: VLOOKUP to fill form from Choices

    You're welcome.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Risk Matrix to auto-fill color based on choices in two other cells.
    By EvalynT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2014, 06:28 AM
  2. [SOLVED] Populate user form based on combobox choices
    By zardof in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-20-2012, 11:08 AM
  3. Combobox to fill textbox with one of 3 choices
    By nighttrainrex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-20-2012, 02:24 AM
  4. Auto Fill 1 Txt from choices of 3 Dependant Combo boxes
    By Sabrina78 in forum Excel General
    Replies: 0
    Last Post: 10-13-2011, 12:59 AM
  5. Making Two Drop down choices work together to fill data
    By fatmaker in forum Excel General
    Replies: 1
    Last Post: 03-07-2011, 07:15 PM
  6. How do I create a form with drop downs that narrows choices?
    By Joeglobal in forum Excel General
    Replies: 1
    Last Post: 07-05-2005, 06:05 PM
  7. Changing Fill color choices
    By Steven in forum Excel General
    Replies: 4
    Last Post: 03-02-2005, 01:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1