Results 1 to 6 of 6

Referncing a price to get the part

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2007
    Location
    Palmdale, CA
    Posts
    10

    References a price to get the part

    I have this spreadsheet that I use for quoting a custom build computer. the options are on the side of the sheet and I want it to automatically add the corresponding part into the system list, I need this to be easily updated and adjustable for different base systems and new parts.

    I just cant get the formula right for it to display the part name in the A column depending on the price entired into the E column. the reference infomation is on the same sheet (part name in the G column and price in J) I have more parts listed in K column and the prices for those are in the N column. I just it to do the reference the different models of the parts not all parts on the sheet

    the sheet is in excel 2007 format
    Attached Files Attached Files
    Last edited by JustCofox; 05-18-2007 at 03:16 AM.

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