+ Reply to Thread
Results 1 to 10 of 10

Excel 2007 : Getting price to autofill after picking product from dropdown list

  1. #1
    Registered User
    Join Date
    02-04-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Getting price to autofill after picking product from dropdown list

    Hi everyone, I am new to the forum and excel so first off, I wanted to apologize for any errors that may occur.
    I am trying to get a price to show up in cell after picking product from dropdown list. The product and price table are in another sheet and are seperated product price - product price, and I donīt know VBA at all if that is necessary.

    The example of the Invoice sheet1 product table sheet2:

    Sheet1
    A------------------------------------------B-----------------------------------------------------------C
    Product Tipe--------------------------Product--------------------------------------------------------Price
    Diverse----------------------------------Washer--------------------------------------------------------0,30


    Sheet2
    A-----------B---------------C------------D----------------E--------------F----------G----------------H
    Diverse----Price--------Steel-------Price-----------Aluminum--------price-------Nickel-------------Price
    washer---------0,30---------1/2--------2.00------------1/4 pipe---------7.00--------sheet-------------2.00

    Hope someone can help.

    Thanks
    Last edited by Luis Honorato; 02-11-2012 at 07:13 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Getting price to autofill after picking product from dropdown list

    Hi and welcome to the forum

    You can do this, using INDEX&MATCH functions.

    =INDEX('PRICE LIST'!B2:B6;MATCH(A2;List;0))

    Hope to helps you.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    02-04-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Getting price to autofill after picking product from dropdown list

    Thanks for replying Fotis1991 but that is not exactly what I need, See the products and prices are in columns product-Diverse-price etc. The problem is that I can get one product and price to work fine, the thing is I have various 4 products columns and 4 price columns. If there was a way to extend formula to involve the rest that would be great.

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Getting price to autofill after picking product from dropdown list

    ..In this case, i think that you must upload a sample workbook.

    It will better for us to understand, what are your needs...

  5. #5
    Registered User
    Join Date
    02-04-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Getting price to autofill after picking product from dropdown list

    Myprob.xls The problem is on the second sheet "IVA" with a small explanation.
    Hope you can help, and thank you

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Getting price to autofill after picking product from dropdown list

    Hi

    Put this formula in J12.

    Please Login or Register  to view this content.
    I Could't type this word,"Latão", so i used referance cell E6!

    Hope to helps you.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    02-04-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Getting price to autofill after picking product from dropdown list

    Thank you very much Fotis1991, itīs done, couldnīt have done it without your help, thanks again.
    Now how do I mark this as Solved?
    Last edited by Luis Honorato; 02-10-2012 at 11:17 AM.

  8. #8
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Getting price to autofill after picking product from dropdown list

    You are welcome!

    Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  9. #9
    Registered User
    Join Date
    02-13-2012
    Location
    bhutan
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Getting price to autofill after picking product from dropdown list

    Hello Fren
    Thanks for the answer, However the problem has arosed in my case dont know what exactly it is. I cud not figure out all i knew is it could be due to some of the addons.
    I made a same Price List and Dropdon list aswel. and i also applied the index and match formula aswel but the answer i get is N/A# WHAT DOES IT MEAN. Plz help me out

  10. #10
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Getting price to autofill after picking product from dropdown list

    Ηι

    This is a new question. So please open a new(your own) Thread, and be sure that will find your answer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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