Lookup functionality and limits

Hi All

Im developing a quotation spreadsheeet where I am using a price matrix supplied in Euro. A part can be selected with a discount applied converted to £ Sterling and then a margin applied.

I have used developer with a active x drop down for search but have hit a problem with lookup as when I tried to amalgimate the price sheets onto one sheet the search function works but the lookup only goes to a specific line and then selects a random set of figures not related to the part selected.

I have now reverted to looking at pulling from each sheet onto a front sheet but this gets messy as I would require 3 to 4 search boxes when I would prefer to search just using the one box and utilising the one lookup formulae.

Any ideas on how to smooth this out or any shortcuts to a more practicle Quote spreadsheet.

These price matrix come out once a year so I need the ability to drop the complete calculation formulae onto the new sheet.

I have attached a copy of the work in progress spreadsheet.

The spreadsheet is the Price Standards SS. Not sure why the other uploaded

Hi
=VLOOKUP($C5,$B$28:$M$596,3,FALSE)

Use this and change the column number

Punnam

That does not work as I need to carry out various calculations and also pull in Row 25 where the additioanl features of the part can be added or extracted.

if a 1 is placed in the FKM cell e6 I need this amount on the price matrix line to add into the total which with your formulae it does not. (and so on along the selection boxes)

With mine it does but only works as far as line 313.then does something funny that I cannot understand.

hi JMac6,
1) It is not clear what is Price Matraix ? specify the range
2) About 1 in FKM E6 what should be happened do it manually for typical case

Punnam