I have an excel spreadsheet that I use for quoting new computer system builds. I'm trying to have it where when i select a cell that it will automatically display the part name in one cell and the cost in a cell next to the name.
for example:
i want to have the parts listed under the A column and the price listed under the C column. I have a selection of between 3 and 5 parts for each component listed next to it one the same sheet, the part names under the "I" Column then an empty cell (Column "J" what I want to use to select the item)then the price of the item the "K" Column.
for like the processor i have 4 different models to pick from, each listed on a different row. (Name of item listed in I1 and and its price in K1, then the next model in I2 and K1 and so on) when I pick the processor i want to use in the quote by putting a X or a 1 on in the "J" Column it will put the name of the processor in the A column on the same row and the price in the "C" column
Plz any help on this would be appricated....GREATLY!!
I already have the sheet set up to total the price of the parts in the "C" Column but I'm stuck at this point.
Bookmarks