Referncing 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

without looking at your sheet, a formula of the type

=if(isna(match(e1,j$1:j$1000,0),"",offset(g$1,match(e1,j$1:j$1000,0),0)))&if(isna(match(e1,n$1:n$1000,0),"",offset(k$1,match(e1,n$1:n$1000,0),0)))

should do it for the price entered in cell e1

I had a ) misplaced.......

=IF(ISNA(MATCH(E1,J$1:J$1000,0)),"",OFFSET(G$1,MATCH(E1,J$1:J$1000,0),0))&IF(ISNA(MATCH(E1,N$1:N$1000,0)),"",OFFSET(K$1,MATCH(E1,N$1:N$1000,0),0))

it sounds like it is a row offset

try

Please Login or Register  to view this content.