Hi

I'm trying to set up a price list, part of which is controlled by a drop down box. The idea is that you select a hardware range from a drop down box at the top of the sheet and the list below updates with the relevant range and pricing automatically.

I've attached a sheet which shows what I'm trying to do - which was easier than trying to explain it!

I'd appreciate it if anyone could point me in the right direction as I have been trying to use the MATCH function and it refuses to work for me.

I'm creating the sheet on excel for windows but it will need to run on Mac 2011 so can't contain any VBA

Thanks

Paul
Hardware Sheet.xls