+ Reply to Thread
Results 1 to 13 of 13

Formulas And Tables Form for Tracking Item Prices

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    lebanon
    MS-Off Ver
    Excel 2010
    Posts
    73

    Lightbulb Formulas And Tables Form for Tracking Item Prices

    Hello,

    I need a table form and formulas that can help me to track a price item.

    for ex: a supplier offered me a price for an item = 20$
    second day he offers me for the same item a price = 30$

    I want to track the price such putting a cell where i type the name of the item will give me the name of the supplier and the price for each day.

    Thanks for helping.

    attached file is a small example.
    Attached Files Attached Files

  2. #2
    Forum Expert 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: Formulas And Tables Form for Tracking Item Prices

    Do you mean something like this?
    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
    11-28-2012
    Location
    lebanon
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Formulas And Tables Form for Tracking Item Prices

    Yes that's it
    I have more than 100 items to add.
    I'll give this a try

    Big Thanks
    Your answer is approved

  4. #4
    Forum Expert 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: Formulas And Tables Form for Tracking Item Prices

    You are welcome!

    Glad that i was able to help.

    Thanks for the reb*

  5. #5
    Registered User
    Join Date
    11-28-2012
    Location
    lebanon
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Formulas And Tables Form for Tracking Item Prices

    Great Thanks For this help.

    I have re attached same file you have sent.
    See what I have done in the attached file.
    Attached Files Attached Files

  6. #6
    Forum Expert 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: Formulas And Tables Form for Tracking Item Prices

    Like this?
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-28-2012
    Location
    lebanon
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Formulas And Tables Form for Tracking Item Prices

    Yes I can See why it's not showing the last two items.
    Big Thanks my Grecian Friend.

    Now I can try it on more than 100 supplier. (If this formula was good or not, let me check it).

  8. #8
    Forum Expert 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: Formulas And Tables Form for Tracking Item Prices

    I'll be here!

  9. #9
    Registered User
    Join Date
    11-28-2012
    Location
    lebanon
    MS-Off Ver
    Excel 2010
    Posts
    73

    Question Re: Formulas And Tables Form for Tracking Item Prices

    Hello Again

    In this sheet we have more than 1 description, how can I track prices in this situation?!?!?!!?!
    And maybe in the sheet 2 I did something wrong with the table I can't see the supplier name when i put the item description

    Thanks for your help

    Its attached with this thread
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    06-14-2008
    Posts
    5

    Smile Re: Formulas And Tables Form for Tracking Item Prices

    Quote Originally Posted by rami10 View Post
    Hello,

    I need a table form and formulas that can help me to track a price item.

    for ex: a supplier offered me a price for an item = 20$
    second day he offers me for the same item a price = 30$

    I want to track the price such putting a cell where i type the name of the item will give me the name of the supplier and the price for each day.

    Thanks for helping.

    attached file is a small example.

    A B C D E F
    1 Item(Write the item you want to search under this)
    2 Flange Ø 325x25mm 500(Price searched) xxx(Supplier Searched
    3
    4 Supplier Name Item description Quantity Prices Total price Supplier Name
    5 xxx Flange Ø 325x25mm 5 500 2500 xxx
    6 yyy Flange Ø 545x30mm 6 520 3120 yyy
    7 zzz Flange Ø 760x30mm 12 333 3996 zzz
    8 zzz Flange Ø 760x30mm 10 352 3520 zzz
    9 zzz Flange Ø 760x30mm 15 332 4980 zzz


    Formula in B2 cell would be : =VLOOKUP(A2,B4:E9,3,FALSE)....this will lookup for the price offered for that particular item
    Formula in C2 Cell would be : =VLOOKUP(A2,B4:F9,5,FALSE)....this will search for the supplier that offered the particular item

    In case the item you search is Flange Ø 760x30mm, this has three prices, but the formula will search from beginning and will return the information of the item when it appears first in the table, so here it will return 333 and zzz

    So this can be used only for unique entries or if you have multiple entries, i would suggest to run the same formula and you will come to know that the item has been offered earlier, and then you can filter the item to compare all the prices that have been offered by that particular supplier for that particular item

    Hope this helps...
    Pooja DSr

  11. #11
    Forum Expert 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: Formulas And Tables Form for Tracking Item Prices

    Hi

    For your second query.

    1) You have to confirm the formula as Array(Control+Shift+Enter-Not just Enter).

    2) This is your formula.

    Please Login or Register  to view this content.
    You must change the red part of the formula to A1.

    For your first question i am not sure what you mean. Can you explain a little more?

  12. #12
    Registered User
    Join Date
    11-28-2012
    Location
    lebanon
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Formulas And Tables Form for Tracking Item Prices

    Hello Again,

    Yes in my first thread I have just uploaded a sheet where I have just 1 description.
    in this last thread I have attached excel sheet where I have more than 1 description.

  13. #13
    Forum Expert 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: Formulas And Tables Form for Tracking Item Prices

    .An answer after so many days. How can i remember...In any case i just see Just one describtion "Perkins UK-Alternator le roy"
    and using my formulas you get the names of 2 suppliers.Ghaddar Machinery Co. S.A.L &
    Jubaili Bros


    So again i don't understand your question. Sorry!

+ 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