Results 1 to 6 of 6

Thread: vlookuo, index, what do I nedd I have tried thse and I cant get them to work

  1. #1
    Seeker GregT's Avatar
    Join Date
    Nov 2019
    Posts
    5
    Articles
    0
    Excel Version
    2016

    vlookuo, index, what do I nedd I have tried thse and I cant get them to work



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Click image for larger version. 

Name:	Screenshot (75).jpg 
Views:	14 
Size:	98.8 KB 
ID:	9423
    I have a drop down list at I7 which I want to drop data into J7 when an item is selected from the list. For some reason the formulas I tried wont work or I am doing something wrong that I cant see. the specs sheet below in columns A and B are the ones that are for I7. Column A is in the drop down list and Column b is for J7. What I need is when fresh yeast is selected only 1% is entered in J7. The same for the dry instant yeast = .03%

    If someone could help I would appreciate it.
    Click image for larger version. 

Name:	Screenshot (76).jpg 
Views:	13 
Size:	95.6 KB 
ID:	9424

    Thanks in advance GregT

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    Administrative Note:


    Welcome to the forum.


    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.


    Read this to understand why we (and other sites like us) consider this to be important.


    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker GregT's Avatar
    Join Date
    Nov 2019
    Posts
    5
    Articles
    0
    Excel Version
    2016
    Ok thks here is the cross link I cold upload images on the otther board that is why I am here

    https://www.mrexcel.com/forum/excel-...dex-match.html

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    Thanks. Be aware that they have the same cross-posting rule.

    Attach the workbook, not pictures of it.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Seeker GregT's Avatar
    Join Date
    Nov 2019
    Posts
    5
    Articles
    0
    Excel Version
    2016
    I apologise m new to these forums I looked where to upload my workbook but I could find a file upload, OR does it need to be in say drop box and a link posted.

    Thanks

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    When you create a post, there is a Go Advanced button bottom right - use that and scroll to Manage Attachments. The rest is pretty obvious.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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