Linking to Database using MATCH and dropdown List

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

Hi

Still don't seem to be able to get this to work Ford, where should the formula you gave me go?

Maybe I've set up the DD wrong?

Regards

Paul

Thanks Ford

Sorry about the red - didn't consider that

Yes to 3, and I think so to 4

Regards

Paul

Hi

I've got the code right but still struggling. I think I need to link each range name to the corresponding items in the range?

So when you select Kytin Range in the DD it populates B11 to B14 with the items from B9 to B12 in the Database and F11 to F14 with prices from D9 to D12 in the database.

and if you then select titan range in the DD it populates B11 to B14 with the items from B29 to B32 in the Database and F11 to F14 with prices from D29 to D32 in the database.

Or am I trying to do something excel can't

Paul
Hardware Sheet.xlsx

Thanks Ford

That's absolutely awesome - exactly what I needed. I was way off on how I was approaching it!

Cheers

Paul